View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tyler[_2_] Tyler[_2_] is offline
external usenet poster
 
Posts: 1
Default 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