Missing Something From Code

Hi,

Here's my code:

Please Login or Register  to view this content.

The idea is to take the columns from table called "AllCancelData" and move them to the Table "AllData". AllData contains the same columns, except it is in a different order.
What you see in the code to set the Arrays are Table Names, not named ranges.

The problem is that right now this macro is moving all columns in vMoveData and pasting them into every column in vDataArea. So by the end, the table "AllData" contains "AllCancelData[Listing]" in every column. I've attached a file in case that explanation was terrible.

I know there is a way to exit a for loop based on a condition, but I tried saying if something wasn't blank then to exit loop, but then it exits after one column is copied. Please help!

You da man, Norie.

Can anyone provide a good learning source for VBA code? I'm self taught so far, but i am looking for a good site to use as a reference when I don't understand things like LBound and UBound (I googled them, but hoping for something that's not just using google)