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,

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" schreef in bericht
...
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

--

Hi Ben,

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

Range("MyNameRange").select

---
Regards,
Norman



"Ben" wrote in message
...
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

--

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

--