Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Happy Holidays everyone!
And speaking of which . . . I'm using a Holiday function that I may have gotten from this group . . . Public Function IsHoliday(CheckDate, Holidays As Range) As Boolean 'Return Trues if the day, dateTime, is in Holidays List Dim c As Range For Each c In Holidays If DateValue(CheckDate) = c Then IsHoliday = True Exit Function End If Next c IsHoliday = False End Function The Holidays List is on a sheet in PERSONAL.XLS The only tiny hitch is that when I use the function it prompts for the Holidays argument but since this is always going to be in the same place I would like this to be automatic. Is that possible by perhaps including its path in the function? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using pulldown list with a list and autocompleet function | Excel Worksheet Functions | |||
Holidays | Excel Worksheet Functions | |||
help to build a list of holidays for 6 years | Excel Worksheet Functions | |||
holidays | Excel Discussion (Misc queries) | |||
Adding a custom function to the default excel function list | Excel Programming |