find row

[CG Rosén]

Good Day,

This is not working;

z = Application.WorksheetFunction.Row(ActiveCell)
MsgBox z.

How to find the row number of the ActiveCell by code?

Thanks for any help.

Brgds

CG Rosén

 

[Chip Pearson]

CG,

Try

Dim R As Long
R = ActiveCell.Row

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Hank Scorpio]

msgbox ActiveCell.Row

Good Day,

This is not working;

z = Application.WorksheetFunction.Row(ActiveCell)
MsgBox z.

How to find the row number of the ActiveCell by code?