Excel VBA
This category will hold articles regarding developement in Excel VBA. It will serve as a wiki and an Excel VBA Framework for myself.
Some development tasks reoccur for every customer. Since I am a lazy bum it will be nice to have a central source where I can reuse source code from.
If you have to delete a worksheet from a workbook, you can use below source code.
Source Code
Referenced Functions
The following functions are referenced.
- Hits: 3541
If you have to search an exact match for a String in an Excel worksheets row, the following function might be of help.
Source Code
- Hits: 2091
The following method returns a Range object referneced by a NamedRange in an Excel worksheet. Motivation for this article is the fact that VBA does not handle possible errors in a NamedRange. If a referenced range contains errors even in formulas, the simple calll to RefersToRange of a NamedRange will fail.
- Hits: 3444
Page 10 of 10