Redifining Named Ranges

[Mike_e]

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:

Dim WS as Worksheet

Set WS = Activesheet

 WS.Range("O6:O7").Names = "Rng" & WS.Name

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

[MickG]

Try .Name, not .Names plural

[Mike_e]

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