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

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

"Dave Peterson" wrote in message
...
Here are a couple of ways.

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

Dave

Many thanks,

V