Hi,
I am a newbee to VBA. Need your help to clarify below:
I have a large spreadsheet with lot of complex formulas. Auto calculation option is already on. It takes few seconds for excel to update the formulas/values after each entry.
I have created a macro to loop through all entries and copy the result to another sheet.
So, wanted to know if I need to pause the macro for excel to finish auto calculations after each entry or this will be done automatically.
Bookmarks