Hyperlink problem

[john dalton]

I have an index page and 140 worksheets, I need A1 in each sheet to hyperlink to the index page, is there a quick way of doing it?

Cheers in advance

[Whizbang]

Please Login or Register  to view this content.

[john dalton]

cheers Whizbang works a treat mate

[abousetta]

Here's a slight twist using the hyperlinks.add function:

Please Login or Register  to view this content.

Hope this helps.

abousetta