Hi Sam,

Sounds like you need a review & update area that users
selects.
Then in the change area cells allowed by user is different
then the review area as selcted by user then easy code can
be used to add the the new row of info. Use the original
Col 1 val then add Alpha or No in text format to keep in
order. I start at row 10 as my labels for list's

Hope this helps

Rgds,
George
Ingleside IL, USA


-----Original Message-----
I want to write a macro that moves the active cell to the
same row but
column 1, then does some stuff, and then exits leaving
the active cell
in column 1 on the next row.

I have the "stuff" working but the user must select the
cell in column 1
before invoking the macro. I would like to remove that
requirement. So I
have to activate (or select? or what?) the cell in column
1 no matter
what column I am in now. How do I do that?
.