L Lino Active Member Joined Feb 27, 2002 Messages 429 Dec 19, 2005 #1 Dim myArray() as string myArray = GetHolidays compiler does not like line above function GetHolidays() as string dim HolidayArray(10) 'populates the array GetHolidays = HolidayArray() end function
Dim myArray() as string myArray = GetHolidays compiler does not like line above function GetHolidays() as string dim HolidayArray(10) 'populates the array GetHolidays = HolidayArray() end function
L Lino Active Member Joined Feb 27, 2002 Messages 429 Dec 19, 2005 #2 i may have figure it out.... the function needs to be: Function GetHolidays() as string() please verify
i may have figure it out.... the function needs to be: Function GetHolidays() as string() please verify
tusharm MrExcel MVP Joined May 28, 2002 Messages 11,028 Dec 19, 2005 #3 Lino said: i may have figure it out.... the function needs to be: Function GetHolidays() as string() please verify Click to expand... Wouldn't it be easier -- and simpler -- and faster -- for you to verify this with a quick test?
Lino said: i may have figure it out.... the function needs to be: Function GetHolidays() as string() please verify Click to expand... Wouldn't it be easier -- and simpler -- and faster -- for you to verify this with a quick test?
L Lino Active Member Joined Feb 27, 2002 Messages 429 Dec 19, 2005 #4 i can't believe u wasted ur time to write that...and i guess the same is true for me...