Paste recordset on next empty row inside a table

**baijixu** · 07-11-2014, 05:03 PM

Hey guy,

Have another one for you. I run the below loop and it works. The problem though is that it pastes the recordset from the access data pull on the first blank line below the table I want it to paste to, almost as if the table is not considered empty, although the table row is in fact empty. In the past process, it even adds two additional lines to my table.

Please Login or Register  to view this content.

Any ideas?

**baijixu** · 07-11-2014, 07:32 PM

I tried this method as well and it yields the same results. It works, but it pastes it on the first blank row after the table. So if the table is 10 rows in size, it will paste starting on row 11.

Please Login or Register  to view this content.

**baijixu** · 07-22-2014, 03:13 PM

Still stuck on this one. Essentially I need it to check a parameter and return a recordset during each loop and append the data to the next blank row on the sheet/table. Any takers?