MaikkiD
06-06-2013, 07:01 AM
Hi All,
I have created my own Worksheet Function that call the bank holiday dates for the year. I am wanting to call the bank holiday dates from the XLSB file so I don't have to change multiple dates each year.
In the XLAM File, I have
Public MBH As Date
Function MBHD() As Date
Application.Run "PERSONAL.XLSB!BankHolidays123"
MBHD = MBH
End Function
And in the XLSB file, I have
Public MBH As Date
Function BankHolidays123()
MBH = #5/5/2014#
End Function
But this isn't working, When I type =MBHD() into a cell, it returns 0 as the value.
Help please? :)
Thanks!
I have created my own Worksheet Function that call the bank holiday dates for the year. I am wanting to call the bank holiday dates from the XLSB file so I don't have to change multiple dates each year.
In the XLAM File, I have
Public MBH As Date
Function MBHD() As Date
Application.Run "PERSONAL.XLSB!BankHolidays123"
MBHD = MBH
End Function
And in the XLSB file, I have
Public MBH As Date
Function BankHolidays123()
MBH = #5/5/2014#
End Function
But this isn't working, When I type =MBHD() into a cell, it returns 0 as the value.
Help please? :)
Thanks!