This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / Help needed! VB expert or Excel Macro expert, pls. help to solve a problem......
-wispylilac(人生若只如初见);
2008-11-20
{1485}
(#4857979@0)
-
=HYPERLINK(CONCATENATE("#",C2,"!","$",C3,"$",C4),"LINK")
-kingsw(Steven);
2008-11-20
(#4858734@0)
-
常规语法： [#[<workbook>]<sheetname>!<range>
示例： #[Parts.xlsx]Sheet1!A1
-kingsw(Steven);
2008-11-20
(#4858748@0)
-
thank you. However this is not what I want. Hyperlink returns the designated text or value, but not the linked value.
-wispylilac(人生若只如初见);
2008-11-21
(#4862229@0)