Identifying the active cell
 

Hi,

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

Thanks in advanc

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

Identifying the active cell
 

Hi Pienpeas,

Dim rw as long, col as long

rw = ActiveCell.Row
col = ActiveCell.Column

---
Regards,
Norman



"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/

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/