liquidmettle
New Member
- Joined
- May 23, 2013
- Messages
- 48
Hi All,
I'm fairly sure this will be an easy one, just can't figure out where I've gone wrong.
I have a sheet named "Update" that I want to put a button on to erase a range (just the contents) on a sheet called "Action Plan".
I do not want to make Action Plan the activesheet, I just want the button to erase it from the Update sheet.
I am trying to use this macro code, but its telling me there is an error:
Sub quarter1()
Sheets("Action Plan").Range("G18:g166").ClearContents
End Sub
Something I'm doing wrong?
Thanks in advance!
-LM
I'm fairly sure this will be an easy one, just can't figure out where I've gone wrong.
I have a sheet named "Update" that I want to put a button on to erase a range (just the contents) on a sheet called "Action Plan".
I do not want to make Action Plan the activesheet, I just want the button to erase it from the Update sheet.
I am trying to use this macro code, but its telling me there is an error:
Sub quarter1()
Sheets("Action Plan").Range("G18:g166").ClearContents
End Sub
Something I'm doing wrong?
Thanks in advance!
-LM