how to auto increment column cell range like initial A1:A12 next i want B1:B12 and so on
Use a loop on it and create a counter int32 type then increment it and pass like this A+coutert.Tostring @Mayur_Pawar
loop as in how ?
Please do this. @Mayur_Pawar
Create a list which has values from A to Z
and in a loop keep on incrementing value of counter over that list.
As a result you will start with range A1:A12 and end with range as Z1 to Z12
In this solution, we would only be able to loop over rows.
We might need one more loop to rotate over columns.i.e A to Z
For column increment
use counter A=65
then in loop increment it
it will give you A
then after increment you will get