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