I am pasting some data from a website onto my spreadsheet starting at cell A1. The data always extends 7 columns across (to Column G). The number or rows always varies from about 500 to 600 rows, but could be more, as the data size varies.

What is a good way to programatically clear away this entire blob of pasted data, and remove the formatting at the same time?

Thanks!