Thread: Loop and delete
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Loop and delete
Hi,

ActiveCell.Offset(0, -42).Range("A1:AS1").ClearContents

HTH
Carim

Reply With QuoteReply With Quote