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