Hi;

I have several named ranges eg "Bar1, Bar2, Bar3 etc" . Each represents 1
column I want to lock. I want to lock and on lock them as a group. I have
tried every way I can think of to use 'Set' but I keep getting error
messages. I would like to lock and unlock them with one statement but if
that is not possible can I just use a 'For Each ' loop?

Can someone get me started on the right path?

Regards bill