Thread: need some help clearing a range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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 With QuoteReply With Quote