Hi,

I have a 3rd-party Excel VBA subroutine that reads a number of cells, performs some calculations, and writes the answers to some other cells. I would like to make the call to this subroutine synchronous, so that control is not returned until after all of the output cells are written. Otherwise, a related calculation may be triggered before all of the results are returned to the worksheet.

Is there a formal command to make the call synchronous? I realize that a cheap (though not entirely foolproof) way of faking synchronicity would be to add a delay to the end of the subroutine to ensure all answers have be written back.

Thanks in advance for your help.

Jeff