Hi Jeffrey,
The way you've done it is correct. It looks as though your experiments
have lead you to the correct conclusion, though I suspect you're a
little unclear why.
If you look at your first function, it doesn't take any inputs, so you
can't use it to reference any other cells when you use
On Aug 9, 1:57 pm, Chris Spicer wrote:
> Hi Jeffrey,
>
> Are you saying that you've written a custom function in VBA and when
> you use the function in the spreadsheet it references the drop down
> list? If this is the case your function should update when you change
> the drop-down list.
>
> I
Hi Jeffrey,
Are you saying that you've written a custom function in VBA and when
you use the function in the spreadsheet it references the drop down
list? If this is the case your function should update when you change
the drop-down list.
If you're using a subroutine, I'd suggest using the 'Ch