Clear range of cells in different worksheet

  • Thread starter Thread starter Tim Kelley
  • Start date Start date
T

Tim Kelley

I need to clear a range of cells in a different worksheet than is the
activesheet. Is there a way to set what worksheet is the current sheet?

Thanks
 
Hi
try
worksheets("other_sheet_name").range("A1:B20").clearcontents
 
You must log in or register to reply here.

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

clear all sheets code 4
Copying cells and formula from closed workbook to all sheets in open workbook 0
How to reference a cell from anther workbook without opening it 0
shorten sheet name 4
Excel VBA 1
Get filtered range into array 20
Excel 2013 Merge Data 2
Arithmetic with Cell Dates 1

Back
Top