Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

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

by dimmesdale (Friar)
on Jul 30, 2002 at 19:14 UTC ( [id://186310] : note . print w/replies, xml ) Need Help??


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

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..