On Jan 15, 4:37*pm, ranswert
wrote:
Is there a way to run the code only when a certain cell is changed? *Not when
any cell on the sheet is changed



"JLGWhiz" wrote:
Use the Change event in the worksheet code module. *Right click the sheet tab
for the sheet where you want the code to execute, then click on View Code in
the pop up menu. *This opens the worksheet code module. *At the top of the
code window you will see General and Declarations in two smaller windows.. *
Click on the General window first, then click Workbook, then select "Change"
from the drop down list. *You should then see the two lines below:

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

The code to be executed for any change to the page can be put between these
two lines.

"ranswert" wrote:

Is there a way to run a macro each time a cell contents are added or changed?
Thanks- Hide quoted text -

- Show quoted text -

If Target.Address = "A1" Then

End If