Basic selection problem

[Yamezz]

I was hoping to accomplish selecting a range in another open workbook in one line of code:

Workbooks("Monthly Activities.xlsx").Sheets("Operations").Range("A1").Select

but for some reason I have to split it up into three lines:

Windows("Monthly Activities.xlsx").Activate
Sheets("Operations").Select
Range("A1").Select

What is the proper syntax for one line?

 

[MARK858]

You can't use select on a sheet that isn't the activesheet try using Goto....

Application.Goto Reference:=Workbooks("Monthly Activities.xlsx").Sheets("Operations").Range("A1"), scroll:=True

 

[Yamezz]

Thanks Mark.