help with code

Hi all, I am very new to VBA and am stuck trying to edit code I already have written. Essentially, the code I have (below) was intended to loop through multiple files in a folder and pull certain data columns in from a specific worksheet. This worked fine for its original purpose, but was only...

Hello, When I add columns in my sheet using <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> Say A B C D E...

Hello world, I am attempting to use a single command button to save two sheets using VBA, but Excel (2010) keeps crashing on me. I'm new to VBA, have learned a ton from the members on here, and I know that I must be doing something wrong. I would like to use a command button located in Sheet1...

OK this is the weirdest thing. I just got a new laptop with Win 7 installed. (Yes we buy old products for new machines to save money.) anyway, this is not my choice. On my XP machine i had a simple paste/special values macro i put in my quick access toolbar because i do a lot of copy/paste. it...

Hello, I'm a new user of VBA and have run into a problem with the (poorly) written code I have made. I have tried to shorten my code by combining common tasks, however it runs but selects the wrong data In the example below, The code returns the expected if I select "M135X" and "300 hrs", but...