Change Worksheet_Change Event to normal macro

The Worksheet_Change event procedure is triggered by changes to the worksheet. If your other sub makes changes to the worksheet, it is in effect calling the Worksheet_Change procedure.


If you want to make it a standalone procedure, You could use just this part of the code.

Please Login or Register  to view this content.

Change the Sheet1 to the name of the sheet that was changed. And define the cRow as the row number that your code changed.

Target is not defined. In the Worksheet_Change procedure, Target is the cell(s) that were changed. In your procedure, you have to specify what cells were changed. You have to define Target as a range of cell(s).