![]() |
When Activating workbook always goes to left most sheet
The following line of code:
Workbooks(AccessSht.Range("CurrInfoBkName").Value) .Activate activates the desired workbook but has started going to the left most worksheet even though the that was not the sheet previously activated. When activating other workbooks similarly the sheet previously active stays active. Any knowledge of what might be causing this? -- CroceJC |
All times are GMT +1. The time now is 04:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com