Select Method of Range Class failed error 400

Hi,

what exactly do you want your macro to do? I don't know where it fails, but I have some points to add:
1. You don't need to select a cell to copy it or assign its value to a variable. Selecting slows the macro down a lot. Instead of

Please Login or Register  to view this content.

you could use this:

Please Login or Register  to view this content.

2. You declared your variables as string (text). Be aware that the cell contents you assign them to will be also in text format!

3. This line kind of confuses me:

Please Login or Register  to view this content.

What exactly do you want to select? The code for selecting the cell right to the activecell is simply

Please Login or Register  to view this content.

4. If you want to know where your macro fails, you can go and exectue it step by step. Just press F8 while the code window is active and it will jump line by line. You can always check what happens after each step. Also, using messageboxes is useful as well. Try inserting lines like

Please Login or Register  to view this content.

to see what value is assigned to a variable. Maybe it's not what you would expect.

Also, please use code tags on the forum for better readability. Hope I helped a little. Cheers!

Thanks so i isolated the error and it is occuring when it trys to select the columns "Columns("A:AZ").select

The purpose of this macro is to consolidate a lot of files into one on different tabs