Redifining Named Ranges

Hi there,

I'm having problems redefining a named range on a worksheet based on a change event attached to a combo box on a form. Here's my code:

Please Login or Register  to view this content.

I've tried numerous variations of the above but always end up with an error message. The above code gives me an "Object Doesnt Support This Method or Property"

I'm sure it's something simple....

Many thanks

Try .Name, not .Names plural

Doh.... I thought I'd tried that....clearly not. Many thanks MickG, all sorted now