View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default 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

--