For Loop Iteration ?

[distantkitty]

Hello there,

I'm trying to initialize a bunch of variables at once, is there a way to do this with a For Loop? I know in some languages I could do it as the following:

  for (int X = 1; X < 51; X++) {
    Msgbox(X)
  }  

I have a set of 50 points, lets say A1:A50 and I'm trying to make each cell a variable.

A1=10
A2=11
A3=12
Etc.

What I would like to do next is then add 10 to each of those variables numerous times (user input). So lets say user inputs 3.
I would like to list the following in new cells, for instance the second run of A1 would start posting at A:51

A1=10
A2=11
A3=12
Etc.

Then
A1=20
A2=21
A3=22
Etc.

A1=30
A2=31
A3=32
Etc.



I've been mulling over this the past few days and I feel my code is super bloated and I know there is a better way of doing this.



TIA!

[:) Sixthsense :)]

Slightly confused about your requirement

What is the purpose of showing 10,20 & 30 in A1 cell?

[AB33]

Here are some of the equivalent loops in VBA. Do not use dollar sign to indicate a variable in VBA. If you use a For Loop in VBA, you do not need to change the loop variable.

Please Login or Register  to view this content.

[distantkitty]

Slightly confused about your requirement

What is the purpose of showing 10,20 & 30 in A1 cell?

Sorry, i didn't explain that well. When the second run of A1:A50 starts, I'd start it at A:51 and third run would start at A:101 and so on.

Thanks!

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[distantkitty]

Does this help?

Please Login or Register  to view this content.

I guess I'm just trying to initialize 50 variables quickly versus manually defining 50 variables.
IE:
A1 = Var1
A2 = Var2
A3 = Var3
---
A50 = Var50

Thanks!

[MrShorty]

It is not clear to me exactly what you are trying to do here. As a guess, it sounds like you are seeking to understand the concept of arrays in VBA (similar to the same concept in other programming languages). Perhaps something like this: https://powerspreadsheets.com/excel-vba-array/
or this: http://www.excel-easy.com/vba/array.html
will get you started. For initializing an array of 50 elements, something like

Please Login or Register  to view this content.