Copying hyperlinks on a 'relative' basis

[Guest]

When I have the formula =hyperlink(a5,a7), and try to copy it down a list of 100 or so rows, the 'a5' part of the hyperlink (the link itself) stays a5 instead of copying on a relative basis (i.e. a6, a7, a8, etc.)

Does anyone know if it's possible to copy these hyperlinks down so that the link changes on a relative basis

I've tried hyperlink(indirect("a"&row(),a7), but it gives me a reference not valid error

Thanks!

 

[Frank Kabel]

Hi scott
works for me. Enteres the following in C1: =HYPERLINK(A1,B1), copied
down will result in =HYPERLINK(A2,B2)
Also your version with INDIRECT works for me.
Frank