I have the code that opens up a new word document using Excel VBA. The worksheet contains dynamically changing data so I can't just copy and paste a range of cells. How can I copy/paste the entire worksheet into Word? Thanks.
I have the code that opens up a new word document using Excel VBA. The worksheet contains dynamically changing data so I can't just copy and paste a range of cells. How can I copy/paste the entire worksheet into Word? Thanks.
Please, explain again why you can't just copy a range of cells?
Because the data dynamically changes and may include more cells than I had originally copied/pasted in the macro. I simply want to select the sheet and have it moved over into Word.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks