Copy Selected Table Rows to Different Table

Closed
RobEBob - Nov 15, 2010 at 05:33 PM
 RobEBob - Nov 15, 2010 at 05:38 PM
Hello,

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.
RobEBob
Related:

1 response

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