MrExcel.com - Your One Stop for Excel Tips & Solutions

Clearing all data in a worksheet using VB

Posted by Geoff on July 10, 2001 10:04 AM

I've looked through all the member functions for a worksheet and couldn't manage to find how to clear all the data on the sheet using VB. Can anyone help me out? Thanks in advance :)

Geoff

Posted by Ben O. on July 10, 2001 11:49 AM

This usually works for me:

Cells.ClearContents
Cells.ClearFormats

-Ben