Yeah OK so my brain is mush.

I have a sheet with a number of incremented links pointing at various pages on a site.
Now I want to turn these into active hyperlinks, WITHOUT doing each individually as I have a ton to do.

So looks a bit like this

http://www.site.com/page1.htm
http://www.site.com/page2.htm
http://www.site.com/page3.htm
http://www.site.com/page4.htm
http://www.site.com/page5.htm

I would like to be able to increment the hyperlink in the same (or similar) way as I drag down to do the numbering.

Any ideas?

Yes I have tried setting the link on the first on and then dragging the series down, but the link itself doesn't change.

If those text strings are in column A starting at A1, put this formula in B1 and copy down:

=HYPERLINK(A1, A1)

Now the links in column B are active and dynamic.

Outstanding cheers JB.

Heh... we are a village!