syntax to go to a named range

[Ben]

Hi all,

I record a macro in Excel to go to a particular name name. It produced
something like this:

Application.Goto Reference:="MyNameRange"

Do you know of a shorter syntax? It just seems to be a long line, since I
have many name ranges. Thanks.

Ben

--

[Norman Jones]

Hi Ben,

If the named range is on the active sheet, try:

Range("MyNameRange").select

---
Regards,
Norman



"Ben" <Ben@discussions.microsoft.com> wrote in message
news:6C3D742D-5BD5-4E80-9C11-DE34F931A48A@microsoft.com...
> Hi all,
>
> I record a macro in Excel to go to a particular name name. It produced
> something like this:
>
> Application.Goto Reference:="MyNameRange"
>
> Do you know of a shorter syntax? It just seems to be a long line, since I
> have many name ranges. Thanks.
>
> Ben
>
> --
>

[Martijn]

Ben,

I don't think there is a shorter one.

In excel you can select the different named ranges by pressing F5 or by
using the dropdown above cel A1.

grtx's Martijn

"Ben" <Ben@discussions.microsoft.com> schreef in bericht
news:6C3D742D-5BD5-4E80-9C11-DE34F931A48A@microsoft.com...
> Hi all,
>
> I record a macro in Excel to go to a particular name name. It produced
> something like this:
>
> Application.Goto Reference:="MyNameRange"
>
> Do you know of a shorter syntax? It just seems to be a long line, since I
> have many name ranges. Thanks.
>
> Ben
>
> --
>

[Ben]

Thanks guys. Works.

Ben

--



"Ben" wrote:

> Hi all,
>
> I record a macro in Excel to go to a particular name name. It produced
> something like this:
>
> Application.Goto Reference:="MyNameRange"
>
> Do you know of a shorter syntax? It just seems to be a long line, since I
> have many name ranges. Thanks.
>
> Ben
>
> --
>