11-26-2024
07:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
11-26-2024
07:44 PM
if you only need to change the Activesheet, better to just define oSheet as such instead of having a For Loop.
Dim oSheet as Sheet = oDDoc.ActiveSheet
And you would have to replace the previous oSheet For Loop's "Continue For" to, possibly, "Exit sub"