D
DCSwearingen
How can I control the worksheet change event? I only want it t
actually run if a value in column 7 (G) is selected.
I want the user to be able to enter data in column 7, run th
worksheet_change event to update values in other columns in the sam
row.
However, as I step through my macro, each time the macro updates th
values in the other columns, the Worksheet_Change seems to run itsel
as a nested routine.
If I update a dozen values based on the users entry, the change i
nested a dozen times.
I am sure there is a limit to how many times this can be down withou
crashing Excel
actually run if a value in column 7 (G) is selected.
I want the user to be able to enter data in column 7, run th
worksheet_change event to update values in other columns in the sam
row.
However, as I step through my macro, each time the macro updates th
values in the other columns, the Worksheet_Change seems to run itsel
as a nested routine.
If I update a dozen values based on the users entry, the change i
nested a dozen times.
I am sure there is a limit to how many times this can be down withou
crashing Excel