Syntax to call a specific workbook and specific worksheet using VBA?

[111StepsAhead]

Sub main0()
    Dim wb As Excel.Application
    Dim ws As Worksheet

    Set wb = GetObject(, "excel.application")
    Set ws = Worksheets("blue")
    
    'wb.Visible = True
    'ws.Activate
    'Range("A1").Select

    wb.ws.rng.Select
End Sub

Is it possible in VBA to combine the 3 lines

    'wb.Visible = True
    'ws.Activate
    'Range("A1").Select

into the following line?

    wb.ws.rng.Select

Basically this is to simplify the room the code takes up. Any help is appreciated.

[JosephP]

no-unless the workbook and range are active you cannot select a range on that sheet

[Norie]

What exactly are you trying to do?

Is there a workbook open when you run this code?

If there was you could use something like this which wil goto A1 on the worksheet Blue in the first workbook

Sub main0()

    Dim wb As Excel.Application
    Dim ws As Worksheet

    Set wb = GetObject(, "excel.application")

    wb.Goto wb.Workbooks(1).Worksheets("blue").Range("A1")
    
End Sub