Thanks for your interest joel, but I just finished hard-coding the Validation
in, because I need the functon to work in xl2000 and the "Pastespecial" model
don't seem to work there. I thought it would be difficult to find the cells
I wanted to Validate, but in my search for a way to do the "Pastespecial
way", I discovered things that helped with the hard-coding and made it a snap.

I appreciate everyone's help
Vaya con Dios,
Chuck, CABGx3





"joel" wrote:


Try doing it manually from the worksheet. Sometimes the error message
are better..


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=180405

Microsoft Office Help

.