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?