I am making a charge sheet on excel and i used the code
Private Sub Workbook_Open()
Range("i5").Value = Range("i5").Value + 1
End Sub
to create a running count every time i open the document. Now i am trying to get the document to delete information that is entered so that way every time i open the document it is cleared and ready to put information in again. I only want to clear certain cells and not the whole spreadsheet.
Bookmarks