| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need some help clearing a range
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need some help clearing a range
think i got this one, too
set rng2 =range(rng.offset(0,-2),rng.Offset(0,5).Address) rng2.clear -- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need some help clearing a range
Try:
Range(rng(1, -1), rng(1, 6)).Clear "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need some help clearing a range
that'll work, thanks
-- Gary "JMB" wrote in message ... Try: Range(rng(1, -1), rng(1, 6)).Clear "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 |
|
#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 |
| Reply |
| 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 | |||
Hybrid Mode
