ongoing question re hyperlink

[stew]

Hi

This is me battling with trying to get a repeitive Hyperlink that takes me
to information that is 103 lines apart on another work sheet.

This Formula is in Row 5 of AI
=HYPERLINK("#'Road Cash Accounting'!,&ADDRES(5+103*(ROW()-409)))-27")

tHE CELL i AM INITIALLY TRY ING TO GET TO IS A111 ON Road Cash accounting.

What Am I doing Wrong
=HYPERLINK("#'Road Cash Accounting'!AI111" gets me there but I want it to
increase to A 214 WHEN
=HYPERLINK("#'Road Cash Accounting'!,&ADDRESS(5+103*(ROW()-409)))-27")
IS IN ROW 6 OF AI

hELP

sTEW

 

[Simon Lloyd]

I don't believe you can do it with formula alone as you cannot check th
state of the ongoing hyperlink via formula, you would probably need VB
to accomplish this

--
Simon Lloy

Regards
Simon Lloy
'www.thecodecage.com' (http://www.thecodecage.com

 

[Pete_UK]

Try it this way:

=HYPERLINK("#'Road Cash Accounting'!A"&((ROW()-4)*103+8),"jump")

This gives the message "jump" in the cell, though you could miss this out if
you wish.

Hope this helps.

Pete

 

[stew]

Dear Pete

Thank You

STEW

Try it this way:

=HYPERLINK("#'Road Cash Accounting'!A"&((ROW()-4)*103+8),"jump")

This gives the message "jump" in the cell, though you could miss this out if
you wish.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Stew - thanks for feeding back.

Pete