So, I have found this works.. Oddly enough, part of the answer was derived from a completely different question.
What I would like to know is how I can use these as global variables across all modules.
Option Explicit Sub SelectPages() Dim WB1 As Workbook Dim SH1 As Worksheet Dim SH2 As Worksheet Set WB1 = ThisWorkbook Set SH1 = WB1.Worksheets("Sheet1") Set SH2 = WB1.Worksheets("Sheet2") SH1.Select SH2.Select End Sub