| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
need some help clearing a range
One mo
rng.offset(0,-2).resize(1, 8).clearcontents Gary Keramidas wrote: rng is a range rng.offset(0,-2).Address ' $A$1 rng.offset(0, 5).Address ' $H$1 how do i clear the range a1:h1? -- Gary -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting/Clearing duplicate range of cells | Excel Worksheet Functions | |||
| Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
| Clearing a Range | Excel Programming | |||
| Clearing a Column range in Multiple Workbooks | Excel Programming | |||
| Accessing/Clearing range in hidden workbook | Excel Programming | |||
Threaded Mode
