Weirdest Program Bug Ever ! Can anyone figure this out ??

[Dan Thompson]

Ok I don't know what is up with this but this has to be the most strange
program bug ever. I have wrote a program in excel VBA that goes out to a
website grabs data then parses it and puts it into a spread sheet. I have
used an Array to store the data it gathered from the website and than put it
into the appropriate columns and rows.
I designed my code to be modular so if I want to add new data sets ie more
columns for more new data all I have to do is add more elements to my
existing array. My Array had 14 elements to it and I have now added two more
elements and two more data columns where the data stored in the new elements
will be placed. Sounds fine right. Well here is the glitch when I added the
new elements to my array (and yes I did remember to RE DIM my Array to
include the new elements) and ran my program nothing happens with the new
elements it's like VBA is not seeing them or ignoring them completely. I get
no errors popping up when I run the code either. The weird thing is if I put
a Watch on my array and than run the code it runs exactly as it should. And
puts the new data from the new elements in my array exactly where it is
supposed to go. So What Gives ?? I am completely confused and frustrated
because it seems that the only way my program will run correctly is if I run
it in debug mode with a watch placed on the problem array. The only thing I
can possibly figure is that maybe I am missing some Microsoft update for my
Excel VBA or somthing. I am running Excel 2003 just for your Info.

ANYONE know what is going on why this is doing this ???

Dan Thompson

 

[RB Smissaert]

Look in your VBA help at ReDim and Redim Preserve.

RBS

 

[Rick Rothstein \(MVP - VB\)]

And you thought keeping the code that is doing this hidden from us would in
some way be an aid to our figuring out what is wrong? <g>

Rick

 

[Dan Thompson]

Well I would have posted the code but there is nothing wrong with the code I
already confirmed that. However since I posted this I left my program for a
day or to and went back to it and ran it again and now it is working fine
without the watches being added when I run it. Go figure huh. So it seams
to work fine now and I have changed nothing since I posted this problem.
Freak'en Microsoft Stuff is so Quarky somtimes.

Thanks Anyhow for those who replied to my post

Dan Thompson

 

[Rick Rothstein \(MVP - VB\)]

The only reason I suggested we would need to see your code is it sounded
like you were describing a timing issue of some kind (perhaps you were using
the Shell command, calling a Timer, something else) and without seeing what
you were doing, there is virtually no way anyone could begin to guess what
to tell you. However, as everything is now working, the issue seems like it
was something other than your code. Maybe your disk defragged was running or
some other CPU hogging process, like an Anti-Virus download, was active
(which, I guess, would still have made it a timing issue).

Rick