Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
jnowel
in reply to: drafting4KGWTN

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"