Automatic detection of a change in a column/cell

  • Thread starter Thread starter Adrian Nightingale
  • Start date Start date
A

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
 
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
 
Back
Top