Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2012, 08:23 PM
macropod's Avatar
macropod macropod is offline Interesting hyperlink macro problem Windows 7 64bit Interesting hyperlink macro problem Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 03-26-2012, 09:26 PM
DobberHockey DobberHockey is offline Interesting hyperlink macro problem Windows 7 32bit Interesting hyperlink macro problem Office 2007
Novice
Interesting hyperlink macro problem
 
Join Date: Mar 2012
Posts: 5
DobberHockey is on a distinguished road
Default

Worked!

Thank you again! All players found and linked
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
hyperlink problem mquest Word 1 01-27-2012 01:55 PM
Making boxes more interesting alexb123 Office 1 01-10-2012 01:27 PM
Word macro to email hyperlink pooley343 Word VBA 0 07-20-2011 01:48 AM
package to cd hyperlink problem yuno PowerPoint 0 06-20-2011 11:09 PM
Creating interesting questionaire waldux Word 0 03-01-2011 12:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft