Change Cell (Col A) when Row is updated - Excel Crashes

[jjhowes]

Trying to change a cell (ie A4) when someone updates any cell in the row (ie row 4), but excel 2016 crashes when code is ran.

Please Login or Register  to view this content.

[mehmetcik]

You have created an endless loop

you change a cell so your macro runs

and the macro changes a cell so your macro runs

and the macro changes a cell so your macro runs

and the macro changes a cell so your macro runs

etc etc till your pc runs oyt of memory and crashes.



Try this:=

Please Login or Register  to view this content.

[jjhowes]

Thank you so very much...