| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Used Range of worksheet?
I have a problem when I am trying to clear all of the data off of a
worksheet except the Header rows. For example I may to clear any row after #7 of all data, I've been using the range A7 to Z55500 EntireRow.Delete BUT Once I've copied the new records to that worksheet and want to loop through them the count Range is really really high 55500+ and includes thousand of blank rows. How can I clear a work sheet without messing up the used range? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you get the range reference for each page in a worksheet print range? | Excel Programming | |||
| Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| How? Macro to copy range to new worksheet, name new worksheet, loop | Excel Programming | |||
Threaded Mode
