Thread: Clear UsedRange except specific cells?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ray Ray is offline
external usenet poster
  
Posts: 267
Default Clear UsedRange except specific cells?
A-HA! Figured it out ... the 'set rp...' line should read like this:

Set rp = ActiveSheet.Range("A4:C4")

NOW it works ...!


Reply With QuoteReply With Quote