DO NOT Copy Data Under Table/ Copy Data from Table to Table

[RoroBear]

Hello Everyone,

As always, any assistance is greatly appreciated! In the workbook, I have to sheets (sheet1 and sheet2) and a button. When clicked, every row in Sheet1 with the cell value ?Complete? is deleted and copied to Sheet2. The data is in tables (Table1 and Table2). The problem is when it copies over, it doesn?t remain in a table format, but rather copies the data under the table. What I want is for the data to copy from table to table. I?ve attached the sample workbook. also posted in VBAExpress: http://www.vbaexpress.com/forum/memb...79150-rorobear

Thank you again!
roro

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[RoroBear]

Thank you very for coming to my assistance. The code doesn't seem to be working. when i press the "Delete Completed Tasks: button i get the following error: Run-time error '91: Object variable or with block variable not set.

[Mumps1]

Try:

Please Login or Register  to view this content.

[RoroBear]

another error, Run-time error '1004: Delete method of Range failed

[Mumps1]

The macro works properly for me using the file you posted. Are you using it on the same file as you posted? If not, post a copy of the file that is generating the error.

[RoroBear]

I'm using the same file, i've even tried creating a new file from scratch and the same thing happens. it's okay, Sheet2 just won't have a Table. Thank you agian, i really appreciate it.

[Artik]

The probable cause of the problems is the disabled automatic expanding of the table.

If it was turned off accidentally, you can use the code below to turn it back on (You can find it manually in the autocorrect settings).

Please Login or Register  to view this content.

But be careful. You may have workbooks that require this option to be disabled. This setting works globally, that is, it is not tied to a single workbook.

The following code does not interfere with the described setting. In principle, this is how we should write code that appends new rows to a table, especially when we have no control over the environment in which the code is run.

Please Login or Register  to view this content.

Of course, it is assumed that there are tables in both sheets.

Artik