in reply to Unable to get the select property of the range class...

Hello again, dimmesdale. You've come a long way with OLE!

About the error - the syntax looks fine. Have you checked the return value of xl_rowcol_to_cell? IME, it looks like the error Excel gives when you try to select a range that extends outside the worksheet. I'd print the results of xl_rowcol_to_cell and make sure that it returns what you think it should.

  • Comment on Re: Unable to get the select property of the range class...

Replies are listed 'Best First'.
Re: Re: Unable to get the select property of the range class...
by dimmesdale (Friar) on Jul 30, 2002 at 19:14 UTC
    That's what I thought (and it may have been).

    (Thanks)

    I changed it to this (I realized I didn't need the select() method to do the rc[-3] type thing) and it worked fine: 

        $rest = 2*$Meas+4;
    $imc  = 2*$Meas+3;
    $avg->Range(xl_rowcol_to_cell($j-1,2*$Meas+5))->{Value}
      = "=ABS(RC[-$rest]-RC[-$imc])";
..etc..

    [download]
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom