Hi
try
msgbox activecell.row

-----Original Message-----
Hi, i'm new to excel programming, and so this is probably
really simple
but how can i find out what row is currently selected?

what i want to do is copy the text from column 1 on
sheet1 to a textbox
on sheet3.

i've been trying debug.print Sheet1.Cells.Row but it
always returns 1.
Please help

thanks, sam.


---
Message posted from http://www.ExcelForum.com/

.