Hi, i'm new to excel programming, and so this is probably really simpl
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 textbo
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

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/

.

Hi
This macro stored in the ThisWorkbook object will display the current
selection row:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
MsgBox Selection.Row
End Sub

Regards
Andrew B



"Chrome " wrote in 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/

Hey thanks works perfectly... and was so simple :D

thanks again

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