Current Row?

C

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 :confused:

thanks, sam
 
A

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
[email protected]
 
Top