Thread
:
Clear Contents
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett