Thread: clear button
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
YMC YMC is offline
external usenet poster
 
Posts: 11
Default clear button



"Dave Peterson" wrote:

Activesheet.Range("F6:G22,K6:K17").ClearContents

(I like to qualify my ranges, too.)


That works perfect! thankyou very much