How to make my range variable?


#1

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


#2

@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”.


#3

@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