Excel: Clear Contents Macro Help

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

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of July 14, 2014.

For more resources for Microsoft Excel