Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Test variable range for 'Delete'; then delete the row | Excel Programming | |||
How to Delete blanks between a range and populate only the names inthe given range | Excel Discussion (Misc queries) | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
cannot delete contitional formatting | Excel Worksheet Functions | |||
Range.Delete and Range.Resize.Name performance issues | Excel Programming |