Questions tagged by "excel-vba"


0
 bounty
0
answers
Excel VBA - how to open CSV file into current workbook
5 years ago • allexx@qrid
I am writing a VBA macro and I need to open a CSV file and load its context into current workbook. Please help!
Tags:
0
 bounty
1
answers
Clear Excel DATA but preserve FORMULAS using VBA macro
9 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?
9 years ago • alex
What is the simplest VBA code to clear everything in the current active worksheet in Excel?
Tags: , ,
1 from 3