How do I find out my row number
 

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

How do I find out my row number
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Neil Bhandar wrote:
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

How do I find out my row number
 

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



"Neil Bhandar" wrote in 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

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
.