Hello,
I have a small function with which I am copying worksheets it looks as follows:
Now as you can see the CopyWorksheet function is called a few times. But for whatever reason this doesnt work. If I remove the "NAAMSNAME" and "NAAMSSHEET" and replace them with text than it will work.Please Login or Register to view this content.
Oh and if it needs to be said, this is supposed to take the caption of a OptionButton, search the workbook for hseets that match the caption text and if there is one do nothing if there isnt. It is supposed to copy a designated sheet and rename it to the Option Button Caption.
Any ideas?
Bookmarks