[SOLVED] automation error on Validation.Add

Hi

Try putting a full stop infront of validation (.Validation).


rylo

that's strange - it had a full period when I copied/pasted it?

here it is:

Please Login or Register  to view this content.

still doesn't work - "object disconnected from clients"

any ideas?

I'm running Excel2003

I'm wondering why it would trigger an Automation Error. The only external object I connect to is a MS Access database but that it not run in this module/procedure, and the error occurs on Validation.Add which should only be connecting to Thisworkbook.Sheets("Design Factor Matrix")

how could I have trouble connecting to that object?

The code is enacted by a button click on a different worksheet, which is why I qualified the range reference

wow! talk about about an obscure error - I never would have figured that out

thanks Andy