Clear Contents
 

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?

Clear Contents
 

Pretty easy

sub clearem
sheets("aa").range("a2:x33").clearcontents
sheets("bb").range("c22:x333").clearcontents
end sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Secret Squirrel" wrote in
message ...
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?