What is wrong with this Macro???!!!!?!?!?!><

**AstToTheRegionalMGR** · 04-17-2015, 01:51 PM

Please Login or Register  to view this content.

The idea is to take data from multiple tables and place them into the sheet called "AllData". It keeps telling me Range of Object failed at the "range(vMoveAllData).Copy" part.

**gmr4evr1** · 04-17-2015, 02:03 PM

what "range" is vMoveAllData? A range is usually something like a cell or sheet reference.....I think.

**AstToTheRegionalMGR** · 04-17-2015, 02:12 PM

vMoveAllData is a list (array) of tables, which I thought constituted a range or multiple ranges

**protonLeah** · 04-17-2015, 02:18 PM

How did you create the tables or named ranges?

**AstToTheRegionalMGR** · 04-17-2015, 02:21 PM

I selected the columns and rows and clicked format as table, then renamed the tables to the names I have listed in the array

**shg** · 04-17-2015, 02:24 PM

Maybe ...

Please Login or Register  to view this content.

**MarvinP** · 04-17-2015, 02:33 PM

Hi,

See if the attached example with code does what you want. I couldn't tell if you had Named Range Tables or Tables of data. See if either/both work with the attached example code.

**AstToTheRegionalMGR** · 04-17-2015, 02:35 PM

I've used this in the past. It suddenly is just not allowing me to use the range("").copy for some reason. It seems if I am using range, it is not going to work. Also, I am using table ranges, not named ranges

**AstToTheRegionalMGR** · 04-17-2015, 02:54 PM

UPDATE: I am a total moron. I had done some work on this recently and changed the name of "ArmenisTable" as part of a test and never changed it back. Thus, VBA did not know what I was referencing. What a waste of an hour... Marking as solved and adding to all your reputations