Thread: Excel Macro for Data Feedback Phonedialer

I have the following situation:

Excel macro cell briefly flashes 0 before updating to new value from an adjacent worksheet. How can I prevent this?

This cell is compared to an entered minimum value in an adjacent cell. If it is lower, than it triggers Phonedialer to call a phone number notifying a person that this minimum has been passed. Thus, when it flashes zero (even though the updated value is not) the condition is met and call is made. The typical minimum that we will be working with is 40, so the brief zero will always trigger the event. I am using excel 2002/sp3 on WindowsXP 2002/sp3

The cell (auto-populated) is commanded:
{=MIN(IF(ExportHere!B2:B65535<>0,ExportHere!B2:B65535))}

Thanks, Steve