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
