Moving to Column A using a macro

[Victor Delta]

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]

Here are a couple of ways.

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

 

[Victor Delta]

Here are a couple of ways.

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

Dave

Many thanks,

V