Copy Range of Cells And Paste Until Last Row

[Unexpc]

Hi guys
i have a page in range A41:H74 and i want copy this page and paste until last row of excel sheet. does any vba code to do this?

 

[Joe4]

another thing, this i ask you, a print page from my main worksheet and i linked main sheet cells to this print sheet. i want when a page fill, next page automatically insert like insert page but automatically, do you have any idea to do this?

That appears to be a whole different question, and as such, should be posted in its own new thread.

 

[Unexpc]

if it happened, why not
Thank you