Macro Hyperlinks with values of cells

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Macro Hyperlinks with values of cells

    Hello,

    at the moment i am jumping between two worksheets with a button and a hyperlink. This works perfect so far with this code:

    Source Code

    1. return __hyperlink('[/LINK/report.wss]#_parent';

    Further i transfer two values of two cells via variables. But i dont like that. If i create a hyperlink in jedox web, i can perfectly transfer as much values as i want from cells in the current sheet to cells in the "new" sheet. Is there any way to realize that with a macro so i can still use my buttons for this.

    Thanks for your help!

  • Hello Pascal,

    I think it can help you!

    Source Code

    1. $NewSheet = activeworkbook()->sheets("Sheet2");
    3. $FirstValue = activesheet()->range("A1")->value;
    4. $SecondValue = activesheet()->range("A2")->value;
    6. $range = $NewSheet->range("B1");
    7. $range->value=$FirstValue;
    9. $range = $NewSheet->range("C2");
    10. $range->value=$SecondValue;
    12. return __hyperlink('[SELF]Sheet2!A1');
    Display All

    Atenciosamente,
    Matheus Luz
    Cel.: 55 11 97053 - 7945
    Site: dimat.com.br
    E-mail: matheus@dimat.com.br

    [Blocked Image: http://www.dimat.com.br/images/site/logodimat.png]