I have a program that needs to read a specific tab of the current open workbook. The workbook's name will vary though so I need it to reference the active one. The program works if the sheet I need to get the data from is active. However,
I'd like it to read that data even if it isn't the active sheet.
Please Login or Register to view this content.
Bookmarks