If Application.CalculationState = xlDone Then


Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

wrote in message
ups.com...
Hi,

I want to use Application.CalculateFull to calculate all the formula on
my spreadsheet. I have some data pulling from Bloomberg so it may takes
some time for the calculations to be completed. Is there a way to know
when the calculations are done? Cause once they are, I want to delete
the row where the data was not pulled from Bloomberg and have #N/A in
the cell.

Thank you,

Kathy