Questions tagged by "excel"


$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: , ,
$0
 bounty
1
answers
MS Excel - how to create a new line in the formula bar?
4 years ago • alex@qrid
MS Excel - how to create a new line in the formula bar? Is there any keyboard shortkey? I've tried Ctrl+Enter combination but that did not work
Tags:
1 - 3 of 3 items