I was wondering if you could send me in the right direction to find info on learning VBA code? I want to learn and I am sure if someone could tell me where to start it would be someone here. Thanks in advance.
Hey there! Well, the first thing I would recommend would be to use the macro recorder and see what it does first. Then go to a used book store and look through the different VB books. Make sure you find one that has language you can understand. Some of the books got way over my head in the beginning. I love Bill's (Mr. Excel) books. Hopefully this will point you in a direction.
By the way, I learned nearly everything I know from this website. Stick around! You are bound to learn a lot!
Besides the many options, (books, CDs, etc.) avalable from MrExcel "himself", and hanging around this board to soak up what you can, one thing you can look into is a site called VBA Express (or VBAX). They offer a real live VBA training course that is very much worth checking out.