Identifying the active cell

[Pienpeas]

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

 

[Norman Jones]

Hi Pienpeas,

Dim rw as long, col as long

rw = ActiveCell.Row
col = ActiveCell.Column

 

[Don Lloyd]

Hi,

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

regatds,
Don