Look in your VBA help at ReDim and Redim Preserve.

RBS


"Dan Thompson" wrote in message
...
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