".Find" Returns Run-time error '91': if the Item Is Not Found.

Hi mehmetcik,

Many thanks for your prompt response. I am not sure what you mean by the following though:

My Rules if you want my help:

1. Please Make Requests not demands, none of us get paid here.

2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.

I was not aware that I had made any demands and this was a new post.

Is it part of a general signature? If so it seems a bit harsh.

regarding your suggestion, in the past I have not had a lot of luck with "On Error" statements and so have tended to avoid them. I will certainly try your suggestion though. I have to say it seems a bit of a weird way to have to do it when it is not really an error, just part of the process.

Regards,
Tegglet

Hi Jazzer,
Getting a bit confused here with all the activity!!! This is in response to all your posts.

It seems to me that there might be an easier solution than hard-coding a date and searching for it, since it seems that this would need to be variable. But I don't quite get what your ultimate goal is.

The hard coding was for the example only. In the real world the variable FirstMonday is loaded by other code.

The ultimate goal is a project started in response to the suggestion you made a while ago about using VBA to construct the workbook from scratch. I was right when I said it was a bit beyond my VBA programming skills, not only am I way out of my comfort zone I have been shot into hyper space!! As Poirot would say it is exercising the little grey cells. ;-)

The current task is to populate the worksheet for each month with receipts received each Monday taking into account Bank Holidays.

I have two receipts every Monday and have successfully populated each monthly sheet with the correct entries assuming no Bank Holidays. The problem arises when dealing with the Bank Holidays.

When a Monday falls on a holiday I get the receipt on the preceding Friday. I have a list of holidays on a separate sheet (to be hidden eventually) which is used by Workday_Intl(....) to get the date of the previous working day. Since Workday_Intl returns the previous workday regardless of whether the seed date is on the list of holidays I need to know if the seed date is on the holiday list before applying it.

I had tried using BankHoliday as Range and using

Please Login or Register  to view this content.

Obviously I had something different as inserting your code seems to work whereas when I tried it before it wouldn't recognise both conditions or I would get the dreaded "Object Variable....Not set" message..

I will continue using your code in the hope there is not something lurking in some dark dank corner waiting to leap out and bit me in the bum!

BTW: I have now got a working sub to find every fourth Friday and populate the worksheets accordingly. It even deals with two Friday receipts in one month. Subs seem easier to get my head round than functions!

Many thanks for your help.
Tegglet