Hi,
I have a excel workbook and I have a bug that occurs occasionally that I have not been able to figure out.
In one worksheet I have an Index Match formula that looks up a code entered by the user and looks up the corresponding item description for that code.
On occasions, this formula does not automatically calculate and I have found that this occurs sometimes after macros are in other parts of the workbook.
Is there a vba command that stops formula's in cells from calculating? Such as -
I have a excel workbook and I have a bug that occurs occasionally that I have not been able to figure out.
In one worksheet I have an Index Match formula that looks up a code entered by the user and looks up the corresponding item description for that code.
On occasions, this formula does not automatically calculate and I have found that this occurs sometimes after macros are in other parts of the workbook.
Is there a vba command that stops formula's in cells from calculating? Such as -
Code:
Application.EnableEvents=False
