Help debugging Macro

Hi,

I don't know what is wrong with this code, but it won't seem to work correctly:

Please Login or Register  to view this content.

The idea of the Macro is to take data from the three tables listed in the array and move them into a table within a sheet called "AllData". The problem is that it's only moving the first line from "ArmenisTable" and the full "BorekTable", and seems to be completely disregarding "BassaniTable". When I'm debugging and I hover over "Range(vMoveAllData).Copy a little pop-up box appears that says "vMoveAllData = "ArmenisTable".

I have no idea what is wrong. My tables all include 4 rows, so I don't understand why they are not all copying over. Please help!

This seems to be working for me: Make sure that all of your tables are correctly labelled and try it

Please Login or Register  to view this content.

@ARowbot:

Your code worked for me. Thank you! However, I'm in a learning process here, so can you explain what was wrong with mine, and how yours, which only seemed to change how the paste area was selected, fixed the code?

Thanks again!

Please Login or Register  to view this content.

Selects the first cell and then moves down to the bottom of the data and offsets by 1. If there are any gaps in Column A then it will go to that cell.
By the sounds of it what happened to yours was that it pasted the first table, then on the row below it pasted the next table and then the next table on top of that one.

The code I used selects the very bottom row in column A and then comes up to the very bottom of the data and offsets it by one row meaning it will always paste at the very end so it doesn't overlap anything previously.

Hope that explains it well enough.