Select All Macro

[gall3on]

Probably silly question...

I know in Excel, there's a function to Select All using Cntrl+A selecting cells that are not empty.

What is the VB equivalent for this if I try to get this in a Macro? I've tried recording it and looked at the code, but all it does is define a range to select (EG: Range(A1:J10).Select)

I know I can use 'ActiveSheet.Cells.Select' to select all cells in a workbook, but that's not what I really want to do.

 

[pbrodsky]

activesheet.cells.select

 

[pbrodsky]

Actually, even just
cells.select

 

[SkipVought]

gall3on,

In the future, if you have VBA questions, please post in Forum707.

BTW, I avoid the Activate & Select methods like the plague!

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[gall3on]

Hm, I actually thought I did post it in the VBA forum. Sorry about that!

And thanks for the Cell Select info. I went ahead and changed the VB script altogether because of formatting issues.

 

[GlennUK]

If you are only interested in the used range of a sheet, then have a look at the UsedRange property.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.