Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

VBA-Excel: Clear data from Excel Sheet(WorkSheet)

VBA-Excel: Clear data from Excel Sheet(WorkSheet)

For­mat: WorkBook.WorkSheet.Range.Clear         



Clear data from par­tic­u­lar cell:

Dim main­work­Book As Workbook

Set main­work­Book = ActiveWorkbook


–Will clear the data from Cell “A2

Clear data from more than one cells:


–Will clear the data from Cell “A1” and “C3

Clear data from range of cells:


–Will clear the data from Range of Cells “A1” to “C4

Clear data from par­tic­u­lar column:


–Will clear the data from entire col­umn “A”

Clear data from par­tic­u­lar row:


–Will clear the data from entire Row 2.

Clear all the Used range of data:


Clear all data from more than columns


–Clear data for Columns from A to F

Clear all data from more than rows



Note: Remem­ber “.Clear” will clear the every­thing from the cell right from cell data to cell for­mat­ting, bor­ders etc

If you just want to clear the con­tent or data of the cells with­out effect­ing the for­mat and bor­der of the cell use “.ClearCon­tents



You may also like...

3 Responses

  1. Lokesh says:

    Very help­ful. Thanks.

  2. anil kumar says:

    please send the vba code for Copy & paste the Entire sheet with data from one sheet to another & auto­mat­i­cally rename the sheet with sys­tem Date

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

%d bloggers like this: