Thank you so much for your attached code. I've tried the same It worked perfectly as you mentioned
Quote:
The code doesn't create a second page. It writes to a second page that you implied existed in your document. If you want a second page you need to add it then reset the range e.g. as attached.
|
Quote:
This will create a new document that is an unnamed facsimile of the original. Or as it is a macro enabled document, you can simply open it as in your subsequent attempt.
|
There should be some way to work on the exisiting Document rather than adding New document. just like in excel you can work on Exsiitng Macro Enabled Workbooks, its worksheets rather than adding new workbook and new worksheet