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
|