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:



Protecting a Workbook in Excel
Protecting a Workbook in Excel
Workbook-level protection- You can apply protection to workbook elements and you can protect a workbook file from viewing and changes.
Difficulty:
Limit the Scrolling Range of Your Worksheet
Limit the Scrolling Range of Your Worksheet
All Excel worksheets created in Excel 2007 have a column limit of 16,384 (256, A to IV, in previous versions) and a rowlimit of 1,048,576 (65,536 pre-2007).
Difficulty:
Auto Fill
Auto Fill
This technique enables excel to copy text/data into multiple cells. You can't work in Excel without knowing this basic procedure.
Difficulty:
Excel 2007 Screen Elements
Excel 2007 Screen Elements
These elements included Office button, Quick Access Toolbar, Ribbon, Name box, Formula bar, Sheet tabs, Status bar, and Zoom control
Difficulty:
3 Special Excel Functions to Amaze You
3 Special Excel Functions to Amaze You
Want to up your Microsoft Excel game? This article will show you how to master three functions that will bring your skillset to the next and make you an Excel Wizard!
Difficulty: