Excel 2010 Macro Tutorial
VBA will be around in Windows versions of Excel through many years to come. There were many unhappy users when VBA was removed from the Mac version of Excel 2008. Microsoft has stated that in the next version of Excel, Excel 15, it will stop providing support for XLM macros. These macros were replaced by VBA in the 1990s and are still supported years later. This Third Edition of VBA and Macros is designed to work with Excel 2010. Visual Basic for Applications (VBA) combined with Microsoft Excel is probably the most powerful tool available for office users. Excel with VBA speeds up the production of any task in Excel. If you use Excel on a regular basis to produce a series of monthly graphs, you can automate that in a few seconds.
> Intro to Excel 2010 Macro Tools
> Excel 2010 Macro Security Restrictions
> Excel 2010 Enable Macros in Workbooks Outside Trusted Locations
> Two Steps to Excel 2010 Macro (Recording and Running)
> Excel 2010 Quick Access Toolbar Macro Button
> Excel 2010 File Extensions
> Intro to Excel 2010 VB Editor
> Excel 2010 Macro Arrays
> Excel 2010 Macro and AutoSum
> Excel 2010 Macro Recorder Tricks
> Excel 2010 Macro Object Browser
> Excel 2010 Control Ranges Using Macro
> Excel 2010 Change Range Size Using Macro
> Excel 2010 Macro How to Check If Cell Is Empty
> Excel 2010 Macro Create a New Range from Overlapping Ranges
> Excel 2010 Macro Check If Workbook Is Open
> Excel 2010 Macro Check If Sheet in Workbook Exists
> Excel 2010 Macro Count the Workbooks in Folder
> Excel 2010 Macro Read Last Saved Time
> Excel 2010 Macro Verify an E-mail Address
> Excel 2010 Macro Sum Cells Based on Color
> Excel 2010 Macro Remove Duplicate Data from a Range
> Excel 2010 Macro Sort Data
> Excel 2010 Macro Search for Text (String)
> Excel 2010 Macro For and Next Loops
> Excel 2010 Macro For Each Loop
> Excel 2010 Macro Controlling the Flow If, Then and Else Statement
> Excel 2010 Macro Select Case and End Select Statements
> Excel 2010 Macro Adding and Removing Names
> Excel 2010 Macro Add Comments
> Excel 2010 Macro Message Boxes and Input Boxes
> Excel 2010 Macro Create a Chart
> Excel 2010 Macro Specify Size and Location of a Chart
> Excel 2010 Macro Specify a Chart Type
> Excel 2010 Macro Change Chart Title
> Excel 2010 Macro Format Line Settings
> Excel 2010 Macro Create Pivot Charts
> Excel 2010 Macro Create Pivot Tables
> Excel 2010 Macro Import from CSV
> Excel 2010 Macro Read Text File
> Excel 2010 Macro Read One Row at a Time from a Text File
> Excel 2010 Macro Export to Word
> Excel 2010 Macro Select or Deselect Noncontiguous Range
> Excel 2010 Macro Schedule Macro to Run Periodically
> Excel 2010 Macro Create Sparklines
> Excel 2010 Macro Scale the Sparklines
> Excel 2010 Macro Format Sparklines
> Excel 2010 Tips for Working with Sparklines
> Excel 2010 Macro Write to a Text File