Exit Function doesn't break out of For loop?

Am writing a simple function to test of the existence of a worksheet in the current workbook

The code below evaluates to false each time even though WsName exists in the workbook wb.

Please Login or Register  to view this content.

A little investigation reveals this is because the Exit Function statement isn't causing an exit of the Function.

My rewrite is:-

Please Login or Register  to view this content.

The rewrite works, just wondered why the Exit Function doesn't work in scenario 1?

In your first macro the for seems to be incorrect. You wrote:

Please Login or Register  to view this content.

but I think you wanted to write:

Please Login or Register  to view this content.

The second macro don't need the exit function because the 'do while.... loop' statement ends when found is true but if you use 'exit function' it doesn't create problems.

In your macro, if you write sheet name to look for in lower case it doesn' find it. It's better if you use lcase or ucase conversione, for example:

Please Login or Register  to view this content.

Regards,
Antonio

Thanks folks.

I spotted the for typo after posting. I like the second form of the function.........

thanks again.

Interesting point - setting

Please Login or Register  to view this content.

Doesn't cause the function to return?