Hi All,
I have the following code in a UserForm to copy a range of cells and paste it into a new workbook.
Unfrotunately, when I do this it makes the new workbook the Active Workbook and the above code fails when it is run a second time. I should also note, I do not want the user to see the workbook behind the UserForm. My current solution to the above problem was to add this code after the paste:
This works well until the user saves the file as another name, then the code fails and i need to manually go in and update it. Is there a way for me to set the workbook with the macros as always the ActiveWorkbook?
Thanks in advance for your help.
Bookmarks