How to make my range variable?

Hello, i need to read a data table that changes
so i have a formula count in my excel to count row’s. number.
i put my count formula in a variable.
My question is how to write my range?
i want to read from A14. i have 12 columns.

Thank you very much for your help

1 Like

@loubna
While reading the Excel you will have an option to declare the range from to end .
There you specify " A14" .
So Data will be extracted from “A14”.

1 Like

@loubna

if you want read single row you could specify read range A14:N14

if you looking for multiple rows then assign the range “A14:N”+Number_of_Rows

Thanks~Rajesh