If Worksheet Exists

Hi guys,

I have a Workbook that creates a new sheet for each member of staff in a list, however I want it to skip any member of staff for which a sheet already exists (avoiding using an error handler).

I have the below, but it seems to try and create sheet even if it exists. Any ideas? Thanks!

Please Login or Register  to view this content.

Hi Chris,

Change this line :

Please Login or Register  to view this content.

To this (excessive one "s" letter) :

Please Login or Register  to view this content.

Regards

Argh! I'm so dumb! Thanks for your help!

You are welcome. It's just a typo, happened all the time


Regards