syntax to go to a named range
 

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

--

syntax to go to a named range
 

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

--

syntax to go to a named range
 

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

--

syntax to go to a named range
 

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

--