View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sieger Sam Sieger is offline
external usenet poster
 
Posts: 2
Default How to activate the cell in same row, column 1?

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?