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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to remove print area when grayed out? 1
Setting Scope of name ranges to particular worksheet 2
Excel Data pastes into 2 cells not 1 1
Macro to clear contents of certain cells 4
Excel 2 into 1 6
Combine multiple ranges into one worksheet 1
VBA code to undo previous VBA action 6
How to copy an Excel worksheet with formulas and clear contents. 2

Top