Excel to Word macro fails when started from another sheet

Hey guys!

I have this macro that exports a table from Excel to Word. It works fine if I run it from the proper worksheet. However if I run it from another worksheet, it copies from row 28, instead of row 173. It is supposed to export the table from row 173 till the last used row. What is wrong with the macro?

Please Login or Register  to view this content.

Thank you in advance!

It's because you define the Lastrow based on the activesheet. Try (untested):

Please Login or Register  to view this content.

Works perfect, thanks!!

You're welcome, glad it worked!