need some help clearing a range

[Gary Keramidas]

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?

 

[Guest]

Try:
Range(rng(1, -1), rng(1, 6)).Clear

 

[Gary Keramidas]

think i got this one, too

set rng2 =range(rng.offset(0,-2),rng.Offset(0,5).Address)
rng2.clear

 

[Gary Keramidas]

that'll work, thanks

--


Gary

Try:
Range(rng(1, -1), rng(1, 6)).Clear

 

[Dave Peterson]

One more:

rng.offset(0,-2).resize(1, 8).clearcontents