Variable Scope in Excel VBA - EASY Excel Macros
Here's a good primer on the scope of variables. Introduction to Variables, Constants and Data Types The macro recorder actually is your friend but look here: Difference between OLEFormat and ControlFormat?įor references purposes and excellent explanations, seeĮxcel VBA MACRO Kick-start Course for absolute beginner If you are serious about learning VBA tryĮxcel Tutorials and Tips - VBA - macros - training There are over 1800 Excel videos/tutorials here: MrExcel's Products: Books, CDs, Podcasts Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts. See if something, in the below link(s), of my most up to date list will help you:
