Help me find whats wrong with my code?

[TomToms]

Hello,

I have a small function with which I am copying worksheets it looks as follows:

Please Login or Register  to view this content.

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.

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?

[Bernie Deitrick]

Try debugging with msgboxes:

Please Login or Register  to view this content.

[TomToms]

Thankyou for the tip, I found with that the the value wasnt being transferred properly. I put the Global Variables inside their own Module and now it works perfectly