Friends,

I have a worksheet with a command button that generates a userform. Upon completion of the user form by the user, it populates fields in my worksheet. The worksheet is laid out to fit on one page when printed with 20 possible new entries from the user.

My problem is that when the first page is filled up and the user clicks the command button, I want a new worksheet to be created exactly the same as the first but with the old data cleared out for the user to continue adding new entries via the userform. The macro I have created works fine except that when I copy the old sheet, create new worksheet and paste, It pastes the old worksheet as an image instead of copying everything into the appropriate cells.

Any idea why?

I have a feeling it has something to do with the fact that I am not copying ONLY cell entries, but also the commandbutton which is an object.

Thanks!