MrExcel Publishing
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