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:



Create a Workbook Splash Screen
Create a Workbook Splash Screen
Splash screens provide that extra bit of polish to an application-not to mention that they keep you entertained while the application loads. Why shouldn't a spreadsheet do the same?
Difficulty:
Unhiding multiple sheets at the same time
Unhiding multiple sheets at the same time
Shows how to hide and unhide multiple sheets at the same time using the AssumeIT macros
Difficulty:
Construct Mega-Formulas
Construct Mega-Formulas
Mega-formulas-a formula within a formula, within a formula-are enough to send even the most seasoned Excel veteran running for the hills. With a little forethought and by working step by step toward the formula you need, however, you can tame those complex mega-formulas without fear.
Difficulty:
Identify Named Ranges on a Worksheet
Identify Named Ranges on a Worksheet
Here is quick method you can use to identify the referenced ranges for each named range.
Difficulty:
Work with Pivot Tables in Excel
Work with Pivot Tables in Excel
PivotTables are one of the wildest but most powerful features of Excel.
We use PivotTables a lot when we develop spreadsheets for our clients. Once a client sees a PivotTable, they nearly always ask whether they can create one themselves. Although anyone can create a PivotTable...
Difficulty: