View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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