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