Different read ranges

excel

#1

I can use the Read Range Activity to read this range: “A5:F61”

However, the range might vary for different files like “A5:F83”. Is there a way I dont have to default it?


#2

Hi @qaz1

If you use "" it will take the entire working range.

You could then delete the first few rows that you don’t need.


#3

Just to inform you, I am using a pivot table… so the first few lines are the filters! I cannot delete them.
Secondly, the when I use “” the formatting would be off when I have to input formulas on a new column.


#4

Hi @qaz1, you could just use “A5”. It will read from A5 till the end.

Cheers.


#5

Thank you!!


#6

No worries, happy automation :slight_smile:


#7