Microsoft Office Forums - View Single Post - [Solved] Interesting hyperlink macro problem

macropod · 03-26-2012, 08:23 PM

Try changing:

Code:

With ActiveDocument.Range
  'Process each word from the Player List
  For i = 1 To UBound(Split(xlFRList, "|"))

to:

Code:

'Process each word from the Player List
For i = 1 To UBound(Split(xlFRList, "|"))
  With ActiveDocument.Range

and:

Code:

  Next
End With

to:

Code:

  End With
Next

As you can see, this is just a simple matter of moving two lines and changing the indenting. The indenting is of no consequence though, to the code's execution.