Loop to populate graph -- Excel "runs out of memory"?

HI, I have a working script that plots 5 sets of data after importing a delimited notepad file. Each column has up to 10,000 data points in it, so I just have it offset by 10,000 rows. Here is the working code I was using as a reference for my question:

Please Login or Register  to view this content.

What I am trying to do is modify it to plot any number of points by making a loop that moves from column to column until it hits an empty column. I wrote the code below, but get an "excel is out of memory" error # 7. I was hoping someone could help me find anything that is wrong:

Please Login or Register  to view this content.

Thanks!

Try declaring the variable DataValue as a long:

Please Login or Register  to view this content.

Place the Dim statement at the top of your sub routine as the first line of code.

I'm honestly not sure. You might also try closing other applications, setting the variable type to double instead of long and making sure Excel is set to use all available processors and that multi-threaded calculation is enabled: Excel Options|Advanced|Formulas.

Thanks for the update.