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 - total earned - 0 BTC ($0 USD)

1
=
0
=
$0
Everyone, even non-registered users could send Bitcoin Tips to YOU if they are inspired by 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

Post Answer


Top 3 Tippers
Recent Tips

Will Bitcoin Tipping become a new Internet Culture?


Please share our story! THANK YOU!