How to get data validation list
Hi,
How can I get a cell's validation list in VBA code?
I know the list can be input manually or programatically
using "Validation.Add", but how to retrieve it in code?
I want to know the valid input range of some cells in an Excel file.
Thanks in advance.
Ting
|