Robert Wyatt
Board Regular
- Joined
- Jul 15, 2012
- Messages
- 88
- Office Version
- 2019
- Platform
- Windows
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.