I currently have a macro that starts when a change is made in a specific range on the worksheet.
My problem is that the macro runs for every cell in the range.
Sample - BT7 value changes to 4. Then the macro is triggered. It compares each cell value in the range to a set of criteria. I only want that specific cell to be recognized because only that cells data changed.
Currently I use "If then" statements to direct from the Worksheet code to six separate 'sub' statements in macros.
The data in the defined range will continue to change as the worksheet is used so i can't compare to a predetermined value.
Is there any hope?
Thanks Again
My problem is that the macro runs for every cell in the range.
Sample - BT7 value changes to 4. Then the macro is triggered. It compares each cell value in the range to a set of criteria. I only want that specific cell to be recognized because only that cells data changed.
Currently I use "If then" statements to direct from the Worksheet code to six separate 'sub' statements in macros.
The data in the defined range will continue to change as the worksheet is used so i can't compare to a predetermined value.
Is there any hope?
Thanks Again