| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ctrl-a
Is there a VBA command that emulates ctrl-a?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ctrl-a
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ctrl-a
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ctrl-a
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a difference between CTRL+D and CTRL+" (quotation marks) | Excel Discussion (Misc queries) | |||
| How to make Ctrl-C, ctrl-V work in Office 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
| Redefining the Ctrl [ and Ctrl ]s short cut with OnKey? | Excel Programming | |||
| Disabling Ctrl-PgUp and Ctrl-PgDn | Excel Programming | |||
![General[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
