View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Moving to Column A using a macro

Here are a couple of ways.

activesheet.cells(activecell.row,"A").select
or
activecell.entirerow.cells(1).select

Victor Delta wrote:

I have written an Excel macro but, before it runs, need to ensure the active
cell is in Column A (of the appropriate row).

Can anyone please tell me how to do this at the start of the macro. I have
searched all over the place for the answer but cannot find it. I could use
the offset command but the number of cells to the left will vary each time.
I thought there might be a Home command or something similar?

Thanks,

V


--

Dave Peterson