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
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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
You have to do it by code:
Names("ABC").Visible = False
or with a utility:
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm
--
Jim
"PraxisPete" <[email protected]> wrote in message
news:[email protected]...
| 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
Thank you for your replies, problem solved.
"Jim Rech" wrote:
> You have to do it by code:
>
> Names("ABC").Visible = False
>
> or with a utility:
>
> http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm
>
> --
> Jim
> "PraxisPete" <[email protected]> wrote in message
> news:[email protected]...
> | 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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks