If I already have a workbook open, and know the name of the workbook, why can't I simply assign the workbook to a variable?
If I have workbook A and workbook B, and both are open.
The code is in workbook A.
Why can't I do something simple like:
Dim wb as Workbook