Hi All,
I'm pretty new to VBA and just discovered how you can use function in excel for different calculations. what I want to know is, suppose I have the following function:
I have two questions, first, how do I load the dates between start and end in to the array myArray? and second, how can I make the array more dynamic so that the amount of indexes in there is equal to end minus start?
thanks in advance
Martin
I'm pretty new to VBA and just discovered how you can use function in excel for different calculations. what I want to know is, suppose I have the following function:
Code:
function dateRange(start, end as range)
dim myArray(5)
I have two questions, first, how do I load the dates between start and end in to the array myArray? and second, how can I make the array more dynamic so that the amount of indexes in there is equal to end minus start?
thanks in advance
Martin