How can I control the worksheet change event? I only want it to
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 the
worksheet_change event to update values in other columns in the same
row.

However, as I step through my macro, each time the macro updates the
values in the other columns, the Worksheet_Change seems to run itself
as a nested routine.

If I update a dozen values based on the users entry, the change is
nested a dozen times.

I am sure there is a limit to how many times this can be down without
crashing Excel.


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=545561