J
jc
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?
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?