Excel not fully calculating before moving on?

M

mxbrunet

I have a VB.NET add-in that does a cpu intensive batch process on a
number of rows (usually more than 1,000). It sometimes happens that the
answer calculated while I'm doing this batch process, and the number I
get when I calculate a single instance of those rows is different.

Would it be possible for Excel to call my VB.Net when it's not finished
calculating and I'm grabbing the wrong value? Would it help if I forced
a calculation using Application.Calculate? (The calculation is
triggered by a range name variable being changed).

thanks.

--max
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation Time 2
Excel not responding before calculations 1
Challenging Excel Problem 0
Excel out of resources - help ! 4
Unwanted Calculation 5
Calculating perfect combination of numbers to end up as close to 1700.0as possible 3
Calculations with possible null value fields 1
Calculate conditiona total at bottom of continuous form. 4

Top