cherryk0317
New Member
- Joined
- Mar 20, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Private Sub CommandButton2_Click()
Range("A5").Select
Selection.End(xlDown).Select
Selection.Offset(1, 0).Select
Sheets("Add Entry").Select
Application.GoTo Reference:="R6C4"
ActiveCell.FormulaR1C1 = Now()
End Sub
currently out file has 900 plus entries and I want to delete the previous data on the file. How do I delete the data without the macro being affected. Deleting the rows prompts that this line as an error.
Range("A5").Select
Selection.End(xlDown).Select
Selection.Offset(1, 0).Select
Sheets("Add Entry").Select
Application.GoTo Reference:="R6C4"
ActiveCell.FormulaR1C1 = Now()
End Sub
currently out file has 900 plus entries and I want to delete the previous data on the file. How do I delete the data without the macro being affected. Deleting the rows prompts that this line as an error.