| 1 |
Auto-Run-Macros |
| 2 |
Excel AutoFilters in VBA using Dates |
| 3 |
Criteria for VBA filters |
| 4 |
Excel VBA AutoFilters |
| 5 |
2 Criteria VLookup for Excel |
| 6 |
3 Criteria VLookup for Excel |
| 7 |
4 Criteria VLookup for Excel |
| 8 |
5 Criteria Vlookup for Excel |
|
|
Excel 2007 Alternative To File Search |
| 10 |
Add Excel Worksheets in Month/Monthly Order |
| 11 |
Add Excel Worksheets in Numeric Sequence |
| 12 |
Add Worksheets to Excel via VBA |
| 13 |
Find Feature to Find 3 Matching Criteria in 3 Columns in Excel |
| 14 |
List/Return Difference Between 2 Cells Containing Comma Separated Strings |
| 15 |
Use Array Elements To Fill a Range With Headings |
| 16 |
Automatically Add Date, Time or Date & Time |
| 17 |
Display Excel AutoFilter Criteria |
| 18 |
Use AutoFilter in Excel VBA to Filter by Date & Time |
| 19 |
Speed up Excel VBA Macro Code |
| 20 |
Functions To Determine Excel Calculation Status & Mode |
| 21 |
Change Text to Upper Case or Proper Case |
| 22 |
Color or Format a Formula Referenced Cells - Precedents |
| 23 |
Copy Multiple Column & Row Records Into Single Row Records |
| 24 |
Loop Through Controls on a UserForm |
| 25 |
Convert a String or Number to Boolean |
| 26 |
Convert a String to a Byte Data Type |
| 27 |
Convert to a Currency Data Type |
| 28 |
Convert to a Date Data Type |
| 29 |
Convert to a Decimal Data Type |
| 30 |
Convert to a Double Data Type |
| 31 |
Convert to a Integer Data Type |
| 32 |
Excel VBA: Convert to a Long Data Type |
| 33 |
Convert to a Single Data Type |
| 34 |
Convert to a String Data Type |
| 35 |
Convert Excel Text To Upper Case |
| 36 |
Convert Numbers to Words/Text |
| 37 |
Excel VBA: Convert to a Variant Data Type |
| 38 |
Count Or Sum Specified Number In a Single Cell |
| 39 |
VBA Count of Each Item in a List |
| 40 |
Count Distinct Values Once/Count Repeated Entries Only One Time |
| 41 |
Custom Excel Function (UDF) that will Count Words in Excel |
| 42 |
Create a Worksheet Calendar |
| 43 |
Excel: Convert Currency Number to Words/Text |
| 44 |
Examples & Usage Of Excel VBA Custom Functions |
| 45 |
Add Quick Access to Excel Custom Lists |
| 46 |
Create Custom Menu Items in Excel VBA |
| 47 |
Cursor Movement Shortcut Keys |
| 49 |
Add/Subtract Dates In Excel VBA |
| 50 |
Debug Excel VBA Macro Code |
