You don't have to use a macro
Check out Datavalidation in the menubar

See text length

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"efi" wrote in message ...
Hi,
How can I insert in my code function that set for a specific column the
validation condition of string 1-15 chars without blanks?

thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/