MrExcel.com - Your One Stop for Excel Tips & Solutions

Run macro when ANY cell in Column A is changed

Posted by JAF on April 19, 2000 3:13 AM

I recently posted a message asking how to run a macro when a SPECIFIC cell was changed (answer provided by Celia).

What I need now is some code to run a macro whenever ANY cell in column A is changed.

Any suggestions?

JAF

Posted by Celia on April 19, 2000 9:05 AM


JAF
Provided input is with the entry key :-

Private Sub Worksheet_Change(ByVal Target As Range)
If ActiveCell.Column = 1 Then Call yourmacroname
End Sub

Celia