Select Range - Excel: The range does not exist error

excel

#1

Good Day

I am trying to Select Range in Excel using a specific range but I get the following error:
Invoke workflow file: Select Range : The range does not exist

The Range used is:
“C21,C23,C45,C46,C47,C48,C49,C50,C51,C52,C53,C54,C38:C44,C55:C71,C2329,C80,C112,C145,C153,C160,C162,C225,C230,C233,C236,C239,C242,C265,C267,C269,C271,C273,C275,C277,C280,C282,C284,C286,C288,C319,C329,C331,C333,C335,C337,C339,C341,C363,C367,C371,C375,C379,C2286,C2288,C2290”

Regardless of what cell I add after “C379” (the fourth last entry), it fails with the error. I do not see any overlapping of cells selected. I am able to manually select those cells in the document in Excel.

Any help would be appreciated.


#2

I would imagine that the activity does not like the number of cells you have specified. Can you use ranges instead? C1:C20 for example OR if you insist on doing it this way - try using a separate activity for half of the cells.


#3

Hi Richard, thank you for your input.
After much investigation, I have come to the following conclusion:
The Select Range activity has a 256 character limit on the input data.
As such, the number of characters entered (and not the number of cells selected) was over the limit which resulted in the error.

Thanks again.