| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
