View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Lloyd Don Lloyd is offline
external usenet poster
 
Posts: 119
Default Identifying the active cell

Hi,

Dim Rw, Col
Rw = ActiveCell.Row
Col = ActiveCell.Column

regatds,
Don

"Pienpeas " wrote in message
...
Hi,

I need to find the location of the active cell by column and row. ie
i(2, 3) I want to run a loop from the active cell onwards, the cell i
am starting from will always be different. I know i can use the
activecell.offset(?, ?). But i only really want to be able to find out
what the active cell row and column are.

Thanks in advance


---
Message posted from http://www.ExcelForum.com/