Hi PraxisPete,

Try something like:

'=============
Public Sub Tester03()
With ActiveWorkbook
.Names.Add "Test", _
RefersTo:=.Sheets("Sheet1").Range("A1"), _
Visible:=False
End With
End Sub
'<<=============

---
Regards,
Norman



"PraxisPete" wrote in message
...
Hi Everybody

How do you create Hidden Names for ranges? I would like to name a range
of
cells and not have the name appear in the drop down Name box, but be able
to
refer to it in VBA code.

I am using Excel 2002

Many thanks