Copy Selected Table Rows to Different Table

 RobEBob -

I am failing at copying selected rows from sheet1's "ActiveItems" table to sheet2's "HistoryItems" table. The copy works fine if "HistoryItems" is NOT a table, but if it IS a table the rows are pasted below the "HistoryItems" table and the table is NOT expanded. I've looked almost everywhere and am still stuck. I really would appreciate some guidance/assistance with this.

Thanks, in advance.

1 reply

Sorry, the environment is XP/SP3 and Office 2007 SP2 and trying to work in VBA.