View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bmwmcrider bmwmcrider is offline
external usenet poster
 
Posts: 4
Default Getting active cell address

Hi,

I am not an Excel VBA expert and have run into a roadblock in attempts
to create a VBA script to manipulate data in S/S cells. What I want
to do is retrieve the address of the active cell. From that I want to
get the row number so that I can go to other cell in that row to read
and modify cell values.

Reviewing all the Excel classes and help files I couldn't seem to
locate a method that returns an object that contains the currently
active cell address.

Any help would be appreciated. TIA ...

Mike