There was discussion last week of the advantage of referring to a worksheet
by Sheet1 rather than WorkSheets("mysheet") or WorkSheets(1). My question
is how to specify what workbook the sheet is in. Nothing I've tried works.
For example I've tried:

Workbooks("mybook").Sheet1

Thanks in advance,

Doug