worksheet delete resets global vba variables !!

[stevebovy]

When I try to delete a sheet, my global varibles go POOF !!!

dim wksheet as worksheet

for each wksheet in worksheets


if ******** then
wksheet.delete
end if

next


or


set wksheet = Activesheet

wksheet.delete


after either of the above all my global vars are destroyed and
any classes of course also go byby

Help me obi wan kanobi !!!!

 

[schielrn]

Welcome to the Board!

Is there any way you can just store these variables to a hidden sheet or a worksheet that is not deleted? Then you don't have to worry about the global variables resetting? Its just one idea.

 

[stevebovy]

Thanks, I have done that partially already, but I also have a class for capturing application events. And when the stupid reset occurs I lose
my application event handling class

Any one out there have any ideas on what is causing the reset ???

Any one else experience this problem ???

 

[stevebovy]

FYI: The reset occurs AFTER the function with the wksheet.delete
exits and goes out of scope.

this is very weird and nasty bugginess !!!