ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Delete range with formatting (https://www.excelbanter.com/excel-programming/455136-delete-range-formatting.html)

Tatsujin

Delete range with formatting
 
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!


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com