Hello,

I have written VBA code that automates some data gathering and computation routines. The problem I have within VBA is that I do not know how to allow sufficient time for the data to be fed into the spreadsheets.

To be more precise, my program does the following:
1. Data is fed into the spreadsheet;
2. A computation is performed; and
3. The above two steps are repeated several times for different data.

I have tried two things: a timer and a Do Until (no #N/A appears within the data set). However, Excel appears to compute only sequentially, and everything comes to a halt.

I would truly appreciate your insight.

Thanks,

Nick