Custom function valid in Data Validation/Conditional Format?

Hi all,

Well, I discovered a while ago that we CAN use custom function on either
Data Validation or Conditional Format? I am trying very hard to verify
myself, but doesn't seem to work either case...

With Data Validation, I am writing a function that returns Range and then
show all the cell values in drop-down box, which I cannot make it happen...

Can someone cast light on this with an example?

Thanks for your time.
---
Tetsuya

Try returning the address of the range and use it inside the indirect
function.

--
Regards,
Tom Ogilvy

"Tetsuya Oguma" <[email protected]> wrote in message
news:[email protected]...
> Hi all,
>
> Well, I discovered a while ago that we CAN use custom function on either
> Data Validation or Conditional Format? I am trying very hard to verify
> myself, but doesn't seem to work either case...
>
> With Data Validation, I am writing a function that returns Range and then
> show all the cell values in drop-down box, which I cannot make it
happen...
>
> Can someone cast light on this with an example?
>
> Thanks for your time.
> ---
> Tetsuya