How do I get the current ROW location.

Craig & Co. · Oct 25, 2004

Hi,

Trying to find out the current row location.

Tried startRow = cell("row")
Tried startRow = ActiveCell.rows.address() - But this returns the column and
row in $A$1 format.

I just want startRow = CurrentRow (or something like this).

Cheers
Craig.

JulieD · Oct 25, 2004

Hi Craig

startrow = activecell.row

Cheers
JulieD

Craig & Co. · Oct 25, 2004

Hi,

Thanks Julie. That's the trick.

Craig.

JulieD said:
Hi Craig

startrow = activecell.row

Cheers
JulieD

JulieD · Oct 25, 2004

you're welcome

Craig & Co. said:
Hi,

Thanks Julie. That's the trick.

Craig.