How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
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.
More cool Excel tutorials:
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.
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).
This technique enables excel to copy text/data into multiple cells. You can't work in Excel without knowing this basic procedure.
Excel 2007 Screen Elements
These elements included Office button, Quick Access Toolbar, Ribbon, Name box, Formula bar, Sheet tabs, Status bar, and Zoom control
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!