Automatic detection of a change in a column/cell

[Adrian Nightingale]

Hi

I need to run some code to export a row from one worksheet
to another when a cell has a date in it, also to remove
the exported row when the cell is blanked, does anyone
know a way of detecting when a cell has been changed ?

Thanks

 

[Greg Wilson]

Right click the sheet tab and select View Code. Then
paste the following to the worksheet code module:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'Your code here.
End Sub

Regards,
Greg