Note:
Excel 97-2002:
Use the shortcut Ctrl-a to select all cells.
Excel 2003:
If the worksheet contains data, CTRL+A selects the current region.
Pressing CTRL+A a second time selects the entire worksheet.
Excel 2007:
If the worksheet contains data, CTRL+A selects the current region.
Pressing CTRL+A a second time selects the current region and its summary rows.
Pressing CTRL+A a third time selects the entire worksheet.
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"General" wrote in message ...
PERFECT .. thanks; "^a" was what i was after.
"Edwin Tam" wrote:
I guess what you meant by "Ctrl-a" is to have all cells selected.
Activesheet.cells.select
Or, if you really want to fire a "Ctrl-a" keyboard instruction, you can try:
Application.Sendkeys "^a"
Regards,
Edwin
On 05/01/2008 7:43 PM, in article
, "General"
wrote:
Is there a VBA command that emulates ctrl-a?