Can not find worksheet

[sbe70]

Hi,
I have a problem I can not solve. I have a list of names that I read from a worksheet. This list includes task these people need to do. I need to create individual worksheets and sort these tasks into the different sheets.

I read the tasks and names as strings. I create the individual worksheets and name them accordingly to each name. When I read the task list I find corresponding name. When I try to select the worksheet with this corresponding name I get an error

Run-time error '9'
Subscript out of range

I can see in Watch that the name string is a direct match to the name of my worksheet. I use the following code

Please Login or Register  to view this content.

Read tasks and find corresponding names

When I try to match the worksheet names with the name string they don't want to match even though the names are the same.

What am I doing wrong? Do I use the declarations correct?

Thanks
Stefan