How to clear current Excel worksheet using VBA macro?

How to clear current Excel worksheet using VBA macro? 28 Apr 2016

No specific Bitcoin Bounty has been announced by author. Still, anyone could send Bitcoin Tips to those who provide a good answer.

What is the simplest VBA code to clear everything in the current active worksheet in Excel?

Tags: excel, excel-vba, vba

Edited Apr 28'16 at 10:27

lampego1@qrid

Created Feb 16'16 at 20:14

alex

ADD COMMENT | SEND TIPS

Internet users could send Bitcoin Tips to you if they like your answer!

I think this is the shortest code snippet to clear an active Worksheet in Excel:

ActiveSheet.Cells.Clear

Besides Clear method that clears everything, Range object also exposes ClearContents, etc, depending on your needs:

Edited Feb 17'16 at 20:18

alex@qrid

Created Feb 16'16 at 20:30

alex@qrid

ADD COMMENT

FavScripts.com is a free tool to save your favorite scripts and commands, then quickly find and copy-paste your commands with just few clicks.

Boost your productivity with FavScripts.com!