Excel increment value

Help
, ,
1

how to auto increment column cell range like initial A1:A12 next i want B1:B12 and so on

1 Like
2

Use a loop on it and create a counter int32 type then increment it and pass like this A+coutert.Tostring @Mayur_Pawar

cheers :smiley:

Happy learning :smiley:

1 Like
3

loop as in how ?

thanks
Cheers :smile:

1 Like
4

Please do this. @Mayur_Pawar

image

cheers :smiley:

Happy learning :smiley:

2 Likes
5

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

6

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

1 Like
7

For column increment
use counter A=65
then in loop increment it
Convert.ToChar(65)
it will give you A
then after increment you will get
B for
Convert.ToChar(66)

1 Like