Is there a VBA command that emulates 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
4651425E-157C-4B0F-816D-(E-Mail Removed), "General"
<(E-Mail Removed)> wrote:

> Is there a VBA command that emulates 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
> 4651425E-157C-4B0F-816D-(E-Mail Removed), "General"
> <(E-Mail Removed)> wrote:
>
> > Is there a VBA command that emulates 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" <(E-Mail Removed)> wrote in message news:95ED49F4-9647-4BC2-A192-(E-Mail Removed)...
> 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
>> 4651425E-157C-4B0F-816D-(E-Mail Removed), "General"
>> <(E-Mail Removed)> wrote:
>>
>> > Is there a VBA command that emulates ctrl-a?
>>
>>