Hello,

Thanks for your help, I filter on one name highlighted the cells but the
ransge included the un-filted names as well - what am I doing wrong?

Kind regards
Kelly

Gord Dibben wrote:
Select a range of cells by CTRL + Click on non-contiguous cells or rows.

With those selected go to InsertNameDefine and give that range a name like
myname

When you go to Allow users to edit ranges simply click on New.

In the refers to: dialog enter =myname

That will also be the Title

Add a password then Apply and Protect Sheet.

Gord Dibben MS Excel MVP

Hi Jim

[quoted text clipped - 12 lines]
Thanks in advance.
Kelly

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201002/1