DougDodge
asked on
How do I set up a variable cell Hyperlink
In the attached workbook on sheet1 the variable date is in cell M6
The formula to find the address is in cell S6
How do I set up a Hyperlink of VBA code to have focus jump to cell CI19?
The date in M6 will change all the time, so the hyperlink must handle that with a formula....
Hylperlink.xlsm
The formula to find the address is in cell S6
How do I set up a Hyperlink of VBA code to have focus jump to cell CI19?
The date in M6 will change all the time, so the hyperlink must handle that with a formula....
Hylperlink.xlsm
ASKER
Thank you for your reply, but neither of your solutions work.
The macro() gives:
Run-time error '1004':
Application-defined or object-defined error
The formula tries to search for a workbook on the network and then fails.
The macro() gives:
Run-time error '1004':
Application-defined or object-defined error
The formula tries to search for a workbook on the network and then fails.
ASKER
The Error with the formula:
Opening c:\Users\ddesk\Desktop\Sit e Progress\Hyperlink.xlsm
Some files can contain viruses or otherwise be harmful to your computer.
It is important to be certain that this file is from a trustworthy source.
Would you like to open this file? OK - CANCEL
Click on OK and get:
An unexpected error has occurred.
Opening c:\Users\ddesk\Desktop\Sit
Some files can contain viruses or otherwise be harmful to your computer.
It is important to be certain that this file is from a trustworthy source.
Would you like to open this file? OK - CANCEL
Click on OK and get:
An unexpected error has occurred.
Hi,
is the excel file the same as in the example
Hylperlink.xlsm
is the excel file the same as in the example
Hylperlink.xlsm
pls try
if the Hyperlink file is already open
=HYPERLINK("[Hyperlink.xls m]Sheet1!" &SUBSTITUT E(ADDRESS( ROW($AP$19 :$OP$19),M ATCH($M$6, $AP$19:$OP $19,0)+COL UMN(AP19)- 1,2),""&RO W($AP$19:$ OP$19),19) ,SUBSTITUT E(ADDRESS( ROW($AP$19 :$OP$19),M ATCH($M$6, $AP$19:$OP $19,0)+COL UMN(AP19)- 1,2),""&RO W($AP$19:$ OP$19),19) )
if the Hyperlink file is already open
=HYPERLINK("[Hyperlink.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works Perfectly..... Thank you.
pls try
Open in new window
or as formulaOpen in new window
Regards