View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default How do I find out my row number

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

-----Original Message-----
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
.