View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_4_] Alan Beban[_4_] is offline
external usenet poster
 
Posts: 171
Default offset property to define range

testRng(4, 1).Resize(3, 3).ClearContents is probably easier.

Alan Beban

Dick Kusleika wrote:
Art

testRng.Cells(1).Offset(3,0).Resize(3,3).ClearCont ents