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 chris.spi...@technicana.com 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