Current Row?

[Chrome]

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

 

[Frank Kabel]

Hi
try
msgbox activecell.row

 

[Andrew B]

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
(e-mail address removed)

 

[Chrome]

Hey thanks works perfectly... and was so simple

thanks again