Repeat last row of table

[jomili]

I'm driving myself batty trying to find what should be an easy solution. All I want to do is copy the last row of my table and paste it into the next row of my table (so my last row is repeated). My latest attempt is below. It Almost works. On the last line, if I add ".Value" after "Lastrow_w_Data)" then the Values from my last row are copied into my new last row. But, I also want the formulas. Hence my code as it stands, which instead only inserts a blank line at the bottom of my table. Why, why, why can't this be easy?

Sorry, but I've been banging my head against this for way too long. I think I've read everything on the internet about working with tables, and I'm frustrated I can't figure it out. So, I'm throwing myself on your tender mercies. Please be kind.

Thanks.

Please Login or Register  to view this content.

[TMS]

Suggest you post a sample workbook. But, try:

Please Login or Register  to view this content.

Regards, TMS

[jomili]

Sample attached. i tried your code, but got an "object required" error on the last line. Story of my life when it comes to this little task.

[TMS]

Oops, sorry:

Please Login or Register  to view this content.

Regards, TMS

[berlan]

Or maybe more robust,

Please Login or Register  to view this content.

and condensed,

Please Login or Register  to view this content.

Cheers,
berlan

[jomili]

Sweet. I was using TMS's solution over the weekend, and saw Berlan's two choices this morning. The condensed appears to do everything I need it to do, short and sweet. Thanks so much for supplying that one!

[berlan]

You're welcome, thanks for the kind feedback

[TMS]

You're welcome. Thanks for the rep.