I'm trying use Excel's Data Validation with a custom validation formula,
but the formula length is limited to 255 characters.

In order to use a longer formula, I've implemented a validation
function in VBA. I can call this function from a cell, but when I try
using it in Excel's custom validation formula, it thinks the function
is a named range.

Is there any fix for this short of implementing validation completely
on my own?

-David


--
dlh
------------------------------------------------------------------------
dlh's Profile: http://www.excelforum.com/member.php...o&userid=26113
View this thread: http://www.excelforum.com/showthread...hreadid=394420