current row - VBA

[chrisdarl]

Hi, i am wanting to find the row number of a active cell. can anyon
give me some code to be able to do this?
Many thanks Chris

 

[DSC]

Hi Chris

Use

Dim ActiveRow as Long
ActiveRow = Activecell.Row
msgbox ActiveRow


This gives the numeric value of the Row that the cell is on

HTH

Davi

 

[TroyW]

ActiveCell.Row

Troy

 

[Pete McCosh]

Chris,

Activecell.Row

Cheers, Pete

 

[jim]

micro = ActiveCell.Row

where micro is a variable

 

[Henk Rek]

What about this;

Sub RowNnumber()
Dim RowNumber As Long
RowNumber = ActiveCell.row
MsgBox ("Row number of the active cell is " & ActiveCell.row)
End Sub

Henk

 

[SidBord]

Hey, try this:
= ActiveCell.Row

 

[chrisdarl]

Thanks everyone for all your help its working fine now.
Chri