How to clear current Excel worksheet using VBA macro?

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

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

Tags: , ,

1 Answer

1
=
0
=
$0
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:

SEND BITCOIN TIPS
1

Too many commands? Learning new syntax?

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!

Post Answer