How do I find out my row number

[Neil Bhandar]

I need to find out the row number of the cell selected.

Here is a piece of code I am working with.

Cells(65536, j).Select
Selection.End(xlUp).Select

I need to find out my position.

Any help is appreciated.
Rgds,
-Neil

 

[Frank Kabel]

Hi
one way:
msgbox activecell.address
or
msgbox activecell.row

 

[Chip Pearson]

Neil,

Selection.Row will return the row number of the selected cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Here's a small routine to demonstrate

Sub Cell_Loc()

Ro = ActiveCell.Row
Co = ActiveCell.Column
CellLoc = ActiveCell.Address
MsgBox ("Row " & Ro & ", " & "Column " & Co & ", " & "Cell
Location " & CellLoc)

End Sub