Range not found when using getRangelist

[Meng Shen]

Hi,

I'm building a range list by creating a  rangeString  . Is there a way to pass it into the getRangeList method ? See below

var coord = [];

for ( i = 1 ; i <= lr ; i++){

if(condition){

coord.push('A${i}')

}}

var rangelist = spreadsheet.getRangeList(coord);

rangelist.clear();

I get this msg when i try to do so :

*Exception: Range not found*

Any help/suggestion will be appreciated

[Tanaike]

In your showing script, you are using coord.push('A${i}')

In this case, coord has ["A${i}","A${i}",,,]

I think that this is the reason for your issue of "Exception: Range not found".

In this case, please modify coord.push('A${i}') to coord.push(`A${i}`) and test it again. Ref

[Meng Shen]

thx, it really does help.