SyntaxFix
Write A Post
Hire A Developer
Questions
Try this
Sheets("your sheetname").range("A5:X50").Value = ""
You can also use
ActiveSheet.range