View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_2_] Robert Crandal[_2_] is offline
external usenet poster
 
Posts: 158
Default Restore a range of cells to "empty"?

One of my sheets is originally empty, but my user will sometimes
paste a group of data to fill the range of A1:H17. Or, they might
also run a macro which dumps data from an ADO Recordset
object that fills the range A1:H17.

How do I restore my range (A1:H17) back to its original empty
state after any of the above operations occur? (How do I do
this using VBA code for Excel 2007?)

Thank you!