PHP Macro Problem

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

  • PHP Macro Problem

    Hi guys,

    I am trying to build a macro which will copy a range of cells and paste the to another. The cells I am copying are dynamic (coming from the PALO.DATA function)

    I am using this script successfully which copy pastes the cell A1 to the range B1:B6

    function copy()
    {ActiveSheet()->Range("B1:B6")->value = ActiveSheet()->Range("A1")->value;}

    However, when I am trying to copy paste a range of cells with the script below, I get an “Application Backend Error 103” and the application collapses..

    function copy()
    {ActiveSheet()->Range("B1:B6")->value = ActiveSheet()->Range("A1:A6")->value;}

    Any ideas???