macro clearing cell content

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a spread sheet given to me and I need some help with the VB/marco in it. The spread sheet has a "clear" button, the script for it is
Range("C4:I73").Select
Selection.ClearContents
Range("E5").Select
I would like for it to clear everything in that area (C4 to I73) but not to clear certain cells for example C29 to I29
Thanks in advance
Tyler
 
Back
Top