find row

  • Thread starter Thread starter CG Rosén
  • Start date Start date
C

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
 
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)
 
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?
Click to expand...
 
Back
Top