How do I find out my row number

N

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
 
C

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
 
G

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
 
Top