Creating a table with VBA using lastrow as range

I need to create a table in VBA for several thosand rows of data, however only with 3 columns. I need to run this daily, however the problem lies in the fact that Column A and Column B will vary in length each day, one day A will be longer, and the next the day B could be the longest, so I cant select the last row of a specific column, I need the last row of A:C

this is what I am currently using, however it is bugging out,

Please Login or Register  to view this content.

Any help is appreciated, thanks!

You don't seem to be giving lastrow a value anywhere.

Anyway, give this a try.

Please Login or Register  to view this content.

PS Can you edit your post to add code tags? Makes things easier to read and copy.