MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Clear range on another sheet

Posted by Jim on April 20, 2001 2:32 PM

Please help with the VB code to clear A2:C100 on Sheet5 when Sheet5 is not the active sheet. Thanks!

Posted by Dave Hawley on April 20, 2001 2:34 PM

Hi Jim


will do the trick.


OzGrid Business Applications