I have several worksheets in a single workbook and I have several VBA
functions used within the workbook that use arguments from different sheets
in the workbook. When the entire workbook recalculates, it appears as if the
VBA macros run several times, even if used only once in the workbook. For
instance, one VBA function displays an error box if certain parameters are
outside of an acceptable range, which is what it is supposed to do. However,
when the workbook recalculates, the error box pops up 4-5 times saying the
arguments are incorrect, but after the boxes are closed everything is
calculated correctly. The function is working correctly, but it is as if
the function ran 4-5 times before the correct arguments where finally passed
to the function.

Is this expected behavior? How can I stop this from happening?

Thanks,

Will

-----------------------------------------------------------------------------
Less Spam Better enjoyable experience
Visit : news://spacesst.com