Questions tagged by "excel-vba"


$0
 bounty
1
answers
Clear Excel DATA but preserve FORMULAS using VBA macro
4 years ago • alex@qrid
How to clear all the data in the current active Excel sheet but keep formula definitions intact? I.e. if I have a table with some columns calculated by formulas, and some other columns containing data loaded from an external SQL database, how do I write a VBA macro that would re-load the data? One of the first steps I would need to do is to clear all the existing data, but preserve all the formula definitions. Looking for a simple code to cle ...
Tags: , ,
$0
 bounty
1
answers
How to clear current Excel worksheet using VBA macro?
4 years ago • alex
What is the simplest VBA code to clear everything in the current active worksheet in Excel?
Tags: , ,
1 - 2 of 2 items