Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

modification of hyperlink name

Hi,
could you tell me why the following code cause an execution error?

For Each h In Worksheets(nomfeuille).Hyperlinks
If InStr(h.Name, "test1") < 0 Then
h.Name = Replace(h.Name, "test1", "test2")
End If
Next

thank

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
macro - modification	yshridhar	Excel Discussion (Misc queries)	10	February 1st 08 03:47 AM
last modification	Chip Smith	Excel Discussion (Misc queries)	1	June 19th 06 11:55 PM
MODIFICATION IS NOT ALLOWED	lisasbulldogs	Excel Worksheet Functions	1	May 31st 06 06:27 PM
Excel2003 Hyperlink Modification	lthrwing	Links and Linking in Excel	1	October 8th 05 03:45 AM
Modification to code	Peter Atherton	Excel Programming	1	September 23rd 03 07:36 PM

All times are GMT +1. The time now is 06:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us