Clear Contents

  • Thread starter Secret Squirrel
  • Start date
S

Secret Squirrel

I have 12 worksheets in my file and I need to clear the contents of only 4 of
them but the ranges I need cleared are different on all 4 of these
worksheets. How can I set up vba code to clear the contents with my specified
ranges and worksheet names?
 
D

Don Guillett

Pretty easy

sub clearem
sheets("aa").range("a2:x33").clearcontents
sheets("bb").range("c22:x333").clearcontents
end sub
 
Top