Clear Contents

[Robert Wyatt]

I would like to know how to write a macro to clear contents in two different spreadsheets with different cells. In the first sheet, I would like to clear the contents in A7, C19:E33, and A36:E36. Then in the second sheet, I would like to Clear the Contents in Cells H34:H35. and H45:H46. I have tired using Sub Clear Contents() Worksheet("1").Range(then the cell range).Clearcontents and Worksheet("1").Range(then the cell range).Clearcontents, but it's not working. any help would be greatly Appersaited.

 

[RoryA]

What exactly did you try and what happened? You need Worksheets not Worksheet but other than that it should work if everything else was correct (and assuming no merged cells).

 

[Robert Wyatt]

never noticed that I didn't put an s on worksheets went back and placed the s and it works thanks.