selecting rows

[lezawang]

Hi
The code below sometime works and some other does not. Specially when I change worksheets(1) to worksheets(2) but anyway now it does not work and I have 2 sheets in this workbook. Thank you so much.

Sub myrow()
    Workbooks(1).Worksheets(1).Rows(2).Select
End Sub

 

[DataBlake]

Hi
The code below sometime works and some other does not. Specially when I change worksheets(1) to worksheets(2) but anyway now it does not work and I have 2 sheets in this workbook. Thank you so much.

Sub myrow()
    Workbooks(1).Worksheets(1).Rows(2).Select
End Sub

you can try this workaround

Sub myrow()
    Workbooks(1).Worksheets(2).Select
    ActiveSheet.Rows(2).Select
End Sub

 

[Fluff]

If workbooks(1) is not the active workbook you will need

   Workbooks(1).Activate
   Worksheets(1).Select
   Rows(2).Select