VBA: Syntax part 2: Objects vs Data types and Declaring Variables
ThatSoBasic.com
For you to safely work with any objects or data types within VBA you'll need the fundamental lessons in this video. Excel will do plenty of guess work if you don't provide good structure to your coding, but I recommend you follow the concepts in this video closely to ensure that your code runs as you expect it to.
There's a tip at the end about removing objects from memory that is important for keeping excel from crashing unexpectedly!
For more info go to:
ThatSoBasic.com