Thread: Cell Deleting and Shifting
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
  
Posts: 644
Default Cell Deleting and Shifting
if all you are wanting to do is clear the data then use .ClearContents
instead of .Delete otherwise I don't quite understand what you are
wanting can you elaborate please?

HTH

Die_Another_Day

Reply With QuoteReply With Quote