Select row in the inactive sheet

[kayza]

Hallo.

I have simple code to select row which located in the inactive sheet, and here is my code

Dim ws As Worksheet
Set ws = Sheets(2)
With ws
    .Select
    .Rows(7).Select
End With

how to select row in the inactive sheet (Sheet2) without abandon active sheet (Sheet1)
thanks in advance

 

[footoo]

Cell selection can only be made on the active sheet.

But cell selection can normally be avoided (and should be avoided in the interest of efficiency).
For example, to copy row 7 from Sheets(2) and paste to row 12 of the active sheet :

Dim ws as Worksheet
Set ws = Sheets(2)
ws.Rows(7).copy Rows(12)

Or if you really wanted to select on another sheet and get back to the original active sheet :

Dim startWS As Worksheet, ws As Worksheet
Set startWS = ActiveSheet
Set ws = Sheets(2)
With ws
    .Select
    .Rows(7).Select
End With
startWS.Select