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

Sheet5.Range("A2:C100").Clear

will do the trick.


Dave

OzGrid Business Applications