Automatic detection of a change in a column/cell
 

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

Automatic detection of a change in a column/cell
 

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

-----Original Message-----
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
.