ctrl-a

  • Thread starter Thread starter General
  • Start date Start date
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
 
PERFECT .. thanks; "^a" was what i was after.

Edwin Tam said:
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
Click to expand...
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CTRL-BREAK Mac 1
macro on different reports CTRL+F in formula 2
Word VBA for deleting Selected Row 0
Excel 2007 Custom ShortCut Keys 1
Command Button Ctrl+Alt+Shift_F9 8
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Disable Ctrl-Break 4
Go back to last step in programming 2

Back
Top