Can you utilize a cell address (B43) in the "Link to:" box of the "Insert>HYPERLINK" function.

I have tried it in any number of ways but still get "Can't open link" error message.

The target cell contains a CONCONICATED (=hypertext() ) link.

Would prefer to avoid a macro if possible.

Thanks for you suggestions.

Michael