locked
VBA Goto Reference RRS feed

  • Question

  • I've been struggling with this one for while, I hope someone can enlighten me!

     

    In sheet1 A1 - I have a list of named ranges. "myRange1" "myRange2" "myRange3" "myRange4"

    How do I write the command for a macro to Goto the current value displayed in sheet1 A1 ??

     

     

    Friday, May 27, 2011 2:48 AM

Answers

  • You problem description suggests you're working with Excel. This is a Word forum. Nevertheless, assuming there's only one named range in A1, try:

    With ActiveSheet
      .Range(.Range("A1").Value).Activate
    End With


    Cheers
    Paul Edstein
    [MS MVP - Word]
    • Marked as answer by Eee_awe Friday, May 27, 2011 5:14 AM
    Friday, May 27, 2011 4:25 AM

All replies

  • You problem description suggests you're working with Excel. This is a Word forum. Nevertheless, assuming there's only one named range in A1, try:

    With ActiveSheet
      .Range(.Range("A1").Value).Activate
    End With


    Cheers
    Paul Edstein
    [MS MVP - Word]
    • Marked as answer by Eee_awe Friday, May 27, 2011 5:14 AM
    Friday, May 27, 2011 4:25 AM
  • Thanks Paul

    Sorry for posting in the wrong forum, but hey a big thanks for your help!

    Much Appreciated

    John

    Friday, May 27, 2011 5:18 AM