Subscribe
Tutorial search

Prevent Case Sensitivity in VBA Code - Excel tutorial


By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This means that it sees Cat and cat as two different words.
Category: Excel > Macros - Difficulty:


More cool Excel tutorials:



Sort by More Than Three Columns
Sort by More Than Three Columns
Excel's Sort feature is limited in that it enables you to nominate no more than three data fields by which to sort.
Difficulty:
How To Use The IMProduct Function
How To Use The IMProduct Function
This video tutorial shows how to use the IMPRODUCT function to multiple two imaginary numbers in Excel.
Difficulty:
MS Excel - Step-by-step guides
MS Excel - Step-by-step guides
Provides free step-by-step how-to articles, tips and techniques, keyboard shortcuts, templates and clip arts for Microsoft Excel
Difficulty:
Password-Protect and Unprotect All Excel Worksheets
Password-Protect and Unprotect All Excel Worksheets
Password-Protect and Unprotect All Excel Worksheets
Difficulty:
Working with Excel 2007 Files
Working with Excel 2007 Files
This tutorial explains how to work with Excel 2007 files.
Difficulty: