Why am I getting a Runtime Error 91?

[compto]

Hi,

This code once worked but now I am getting a Run-time Error 91: Object variable or With block variable not set.

Can anyone help me to understand why?

Thanks

Please Login or Register  to view this content.

[Norie]

It's probably because what you are trying to find isn't there and/or you are looking in the wrong place or for the wrong thing.

Does this work?

Please Login or Register  to view this content.

[compto]

It did work once though.. I don't understand why it would no longer work after I haven't changed anything. And no that doesn't work either.

[compto]

double post, sorry

[Norie]

Which line do you get the error on?

Has the workbook stayed exactly the same?