Beginner VBA error

Please use Code Tags when posting code (Forum Rule #3)
Add this to the function.

Please Login or Register  to view this content.

This is the "information age" not the "good information age". Most of the code you will find online is either written by people helping someone else and they are going to write it as short as possible to save time and/or it was written to accomplish a very specific task in a very specific context which may (almost 100% never) not match your needs. VBA is not one size fits all.

Generally when you find code online (or even when you record code) you need to dissect it, pull out what you need and/or re-write portions of it to meet your needs. There are often things I add to code I find to complete it like declarations, constants, comments, and error handling.

Its also important to know how old the code is and what version of Excel it was meant to work with. When I write my own code I always comment it to include the date and what version I made it in. Often going back to my own code (or code you find online) it is outdated compared to what version of Excel you may now be using. Sometimes its a simple fix sometimes it requires a new approach.

If you are a programmer yourself or aspiring to be a VBA programmer then you are better off using online code as an example and learning how/why it works, then writing it yourself to match your own style and your existing code. I often dig up code online to do something and find someone else doing it a way I would not have thought of. I dont however take it at face value, but instead try and understand why it works, what conditions it may not work under, test it and then incorporate it into my code by writing it to match how I write code myself. I may only use portions of it, or adopt its approach but in another way.

Glad to help. Thanks for rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

http://www.cpearson.com/Excel/DeclaringVariables.aspx