View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wild Bill[_2_] Wild Bill[_2_] is offline
external usenet poster
 
Posts: 90
Default Deleting/Replacing Values in a Range

..clearcontents and .clear wipe out the whole range.

I can't imagine anything more efficient than what you first came up
with, for the selective processing you indicate.