Hi, Does any one know of a way to clear/delete a range when the save icon is pressed or when someone goes to file save as etc? I have tried....
Code:
Sub ThisWorkbook_BeforeSave(ByVal SaveAsUI As Boolean, ByRef Cancel As Boolean)
Worksheets("sheet2").Range("B2:B100") = ClearContents
End Sub
Within 'thisworkbook' but its not working for me. Has anyone done anything like this before?Dave :-D