I can't figure out why I am receiving a run time error '91'?

[redsab]

Picture1.jpg Picture2.jpgI have used the 'Set' command to set my object and I am still receiving this error message. Everything looks correct to me, but I have missed something somewhere. Here is part of my subprogram:

Please Login or Register  to view this content.

Thanks for your help.
redsab

[Norie]

Where do you get the error?

[redsab]

Norie,

Please Login or Register  to view this content.

Picture2 shows the exact point in my code. Thanks redsab

[Philb1]

Hi redsab
You don't "Set" Long variables
You need to use something like this

Please Login or Register  to view this content.

[Philb1]

I was a bit vague in the last post, try something like this

Please Login or Register  to view this content.

[Norie]

The problem is probably caused by Find failing to find what you are looking for.

When that happens Nothing is returned, and it you try and find the Row of Nothing you'll get the 'Object Required..' error.

[redsab]

Philb1,
I tried that and got the same results. I worked with my code and changed things around and nothing worked until I red Norie's post. I checked the values in Sheet1 and I was 100% that they were correct, however, I checked my format on those cells and they were listed as Accounting, when I changed it to Text my program was able to work. Also your code works also. Here is my final subprogram:

Please Login or Register  to view this content.

Thank you very much for your help!
redsab

[redsab]

Norie,
You were exactly right. I had to change my number format from Accouting to Text and then my program worked fine. Thanks for your help!

redsab