How would one clear the range B1:G6 on Sheet1 (which is not the active sheet)?
O ordnance1 Nov 8, 2009 #1 How would one clear the range B1:G6 on Sheet1 (which is not the active sheet)?
A arjen van der wal Nov 8, 2009 #2 Sheet1.Range("B1:G6").ClearContents or Sheets("Sheet1").Range("B1:G6").ClearContents
