Expert Needed: How do you in a loop or with an array go from
to this, without copying and pasting and changing variable1..2..3.4..5
I am trying to create a loop or an array which instead of copying and paste the bottom line and code and making Variable1 to Variable 2 and VariableDbl1 to VariableDbl2. The thing which I was having a problem was is how to increment a String or make a variable with an incremented value after it. Any thoughts?
I had to do Dim Variable1 as String, then convert it to double afterwards, because or else it would give me a Compile error: ByRef argument type mismatch.
Instead of making a 5 of these:
Thanks in advanced
Bookmarks