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 |
Custom function valid in Data Validation/Conditional Format?
Try returning the address of the range and use it inside the indirect
function. -- Regards, Tom Ogilvy "Tetsuya Oguma" wrote in message ... 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 |
All times are GMT +1. The time now is 12:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com