Why did you flip the order of the lines of code I gave you?
You are trying to use the "lr" variable in the copy command before you calculate it/
You must calculate "lr" first before you can use it!
I also left it to you to enter where you want to copy it to (you did not mention where this should be copied).
So you still need the paste postion of the code. If you need help writing that, you need to tell us how to determine where to paste this to.
i have a page from row 41:41 to 74:74 with specific format and data
in my row height , each page have 34 row and i have 8 column that fitted like my page in A41:H74
i want copy from this page and pasted in each page until rows excel is ended (row 1048576)