Get the row number of the active cell

    Get the row number of the active cell

    Hello,

    I am looking for the row number of the active cell.

    I found how to change the height of the active cell (activesheet()->row(0)->height(30);) but I have no idea what to use to get the row.

    E.g. Cell B6 is selected and I start the macro I want to get 6 within the macro.

    Thanks a lot in advance,

    Olaf.
    Hello,

    thanks a lot. The hint with regtex was very helpfull as well !!!

    function test()
    {
    $address=activerange()->address;
    $pattern='/[0-9]+/'; //looks for all numbers at the end of the string
    $success=preg_match($pattern, $address, $match); //looks for the pattern in address and stores the result in $match
    return __msgbox($match[0]);
    }

    Kind regards,

    Olaf.