I have problem with using Read range activity
What do you think it could be?
mybe you combining modern design activities with clasic design activities. Check on the read range properties the Activity type:
Classic Excel Application scope can be combined with:
But should not be combined with:
I would recommend using either classic or modern but not a combination of both.
My preference would classic as the Sheet name is accepted as a string.
With the modern Excel activities on the latest versions, you have to use expressions not just strings.
Excel.Sheet(“Sheet1”)