macro clearing cell content
 

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

macro clearing cell content
 

Range("C4:I28£¬C30:I73").ClearContents

macro clearing cell content
 

Range("C4:I28,C30:I73").ClearContents

-----Original Message-----

Range("C4:I28£¬C30:I73").ClearContents



.