macro code for select all

[kylefoley76]

i record macro and hit select all and that action won't record. what's the macro code for select all in excel. i assumed it was the same as word

selection.wholestory

but it's not

 

[Armando Montes]

Try

Cells.Select

 

[Norie]

Select all what?

All the cells in a worksheet?

Cells.Select

 

[kylefoley76]

thanks

 

[Smitty]

Uhhh, why bother selecting? It's generally unnessary. What else are you trying to do other than select the whole sheet?

 

[leanneypants]

Personally I need to use select all FILLED cells in Macros as I copy data between tabs and the destination area is surrounded by other formulas.

So I use this:

ActiveSheet.UsedRange.Select

 

[Michael M]

But you could use, for instance
So select isn't necessary

ActiveSheet.UsedRange copy destination:=Sheets("Sheet2").range("A1")

 

[Smitty]

Welcome to the Board!

Personally I need to use select all FILLED cells in Macros as I copy data between tabs and the destination area is surrounded by other formulas.

So I use this:

ActiveSheet.UsedRange.Select

You might want to look at SpecialCells.