I have a macro that I wrote that generates a calendar for me when I put a start date in cell A1. I also have a list of holidays and their dates.
I need a way to search the range of holidays and have it replace the date with an "H" in the calendar range.
I have attached my workbook. Any help is appreciated.
Last edited by Ricker090; 08-10-2011 at 04:59 PM.
How about this:
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
That's interesting. I didn't even think about using the "countifs" function. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks