Using Excel 2002 and 2003.
Have come across situations where a public variable that was initialized
before later for no obvious reason became uninitialized. I couldn't find any
reason at all for this in my code. I just made sure that when the variable
was needed
it got initialized again.
I just read in the book Excel 2002 VBA by Stephen Bullen et al. the
following text (in a bold textbox, page 297):

There have been (relatively rare) cases, in Excel 97, where bugs in Excel
have caused variables to reset.
It would be wise to expect that bugs could also exist in later versions.

Is this known to happen in later Excel versions?
Are there particular situation where this is more likely to happen?

Thanks for any insight in this.


RBS

You didn't end your code (by clicking on the Reset button in the VBE)?

And you don't have any END's in your code?
(not "end with" or "end if", but bare naked End's???)

Maybe one more look through the code would be in order.

RB Smissaert wrote:

Using Excel 2002 and 2003.
Have come across situations where a public variable that was initialized
before later for no obvious reason became uninitialized. I couldn't find any
reason at all for this in my code. I just made sure that when the variable
was needed
it got initialized again.
I just read in the book Excel 2002 VBA by Stephen Bullen et al. the
following text (in a bold textbox, page 297):

There have been (relatively rare) cases, in Excel 97, where bugs in Excel
have caused variables to reset.
It would be wise to expect that bugs could also exist in later versions.

Is this known to happen in later Excel versions?
Are there particular situation where this is more likely to happen?

Thanks for any insight in this.

RBS

--

Dave Peterson

http://support.microsoft.com/default...21&Product=ofw
OFF97: Displaying UserForm Designer Resets Global Variables

--
Regards,
Tom Ogilvy


"RB Smissaert" wrote in message
...
Using Excel 2002 and 2003.
Have come across situations where a public variable that was initialized
before later for no obvious reason became uninitialized. I couldn't find
any
reason at all for this in my code. I just made sure that when the variable
was needed
it got initialized again.
I just read in the book Excel 2002 VBA by Stephen Bullen et al. the
following text (in a bold textbox, page 297):

There have been (relatively rare) cases, in Excel 97, where bugs in Excel
have caused variables to reset.
It would be wise to expect that bugs could also exist in later versions.

Is this known to happen in later Excel versions?
Are there particular situation where this is more likely to happen?

Thanks for any insight in this.


RBS

I thought it did happen without the VBE being open at all, but maybe I am
mistaken.
Will see.

RBS


"Tom Ogilvy" wrote in message
...
http://support.microsoft.com/default...21&Product=ofw
OFF97: Displaying UserForm Designer Resets Global Variables

--
Regards,
Tom Ogilvy


"RB Smissaert" wrote in message
...
Using Excel 2002 and 2003.
Have come across situations where a public variable that was initialized
before later for no obvious reason became uninitialized. I couldn't find
any
reason at all for this in my code. I just made sure that when the
variable
was needed
it got initialized again.
I just read in the book Excel 2002 VBA by Stephen Bullen et al. the
following text (in a bold textbox, page 297):

There have been (relatively rare) cases, in Excel 97, where bugs in
Excel
have caused variables to reset.
It would be wise to expect that bugs could also exist in later versions.

Is this known to happen in later Excel versions?
Are there particular situation where this is more likely to happen?

Thanks for any insight in this.


RBS