would this code find a worksheet that his hidden ?

Hello,

I have this code which looks for a sheet with the chosen name, if it's there it simply adds a one to the existing count.

Please Login or Register  to view this content.

anybody know if this will find hidden sheets ?


Thanks in advance,

spyrule

Heh,

actually no I havn't yet, because to do so, would take a somewhat rather time consuming effort to do, when this is generally a MUCH faster answer. Which is why I love this forum. Open minded, helpful, and on-topic, and best of all peer(some more then others based replies.

any idea though?

thanks,

spyrule

LOL!.

Thanks dave, your test is soooo much simpler then my over complicated
mind thought out.

hey, while your here, does UCase(variable) work in vba? I'm trying to
convert a textbox.text to all upper case. Any fast way of doing this?

I have

FNameInput = UCase(FNameInput)
LNameInput = UCase(LNameInput)

but I keep getting UCase is not a defined function.

I cannot seem to find a function to convert a string to all uppercase.

Is their one?

Thanks a HUGE amount dave, you really are under-apreciated, except by me!

Oliver.