b_choplick
New Member
- Joined
- Jul 17, 2014
- Messages
- 9
I am attempting to create a macro that will move all active sheets to a new Word document. I have written the macro to hide and unhide the proper sheets depending on different variables, but am lost moving forward with the export to Word. Can anyone help me with this? I also wouldn't be opposed to rewriting the macro to just select the proper sheets (instead of hiding and unhiding) and then moving all selected to a new Word document if that is more attainable.