selecting all cells in a sheet

S

Saravana

hi all,

this is what my problem is...

i have a sheet which contains formulas that refer to another excel
file. my concern is that i want the values alone without formulas. i
also want to know the command which will select all the cells in
particular sheet.

Can some one pleas help me in this ?
 
P

Patrick Smith [MSFT]

If you need to have only the values and wish to remove the formulas, then
you can copy all of the cells and then paste values over the same range.
This will remove your formulas and leave you only with the values that were
there when you copied.

To select all of the cells in a worksheet via code, just do a:

cells.select

Hope this helps,
 
C

Chris Smith

Patrick,

Did you get a repro on the Excel 2007 bug I sent to you both via email and a
followup to your post in the "Excel 2007 Beta 2 problem moving worksheets
via VBA macro" thread on 31st May? I just want to be 100% sure this one
makes it to the bug database!


Chris.
 
Top