View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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

--