Reg. Strings in for loops

[jonastjader]

Hi,
I want to make the string variable j go through different strings (to assign different Cells columns such as "A" or "B"). With integers it is easy:
Dim i As Integer
For i = 1 To 24

But how can I do a similair thing with strings? Or maybe assign so that 1,2,3 will be converted to A,B,C inside the for loop?
Dim j As String
For j = "A" To "C"
This does not seem to work...

Best,
Jonas

 

[Rick Rothstein]

Hi,
I want to make the string variable j go through different strings (to assign different Cells columns such as "A" or "B"). With integers it is easy:
Dim i As Integer
For i = 1 To 24

But how can I do a similair thing with strings? Or maybe assign so that 1,2,3 will be converted to A,B,C inside the for loop?
Dim j As String
For j = "A" To "C"
This does not seem to work...

Using an modification of the method I posted to your other thread (where you asked this question for the numbers 1 thru 24) here...

http://www.mrexcel.com/forum/excel-...values-help-integer-variable.html#post3682418

this is how I would do it...

Sub ForLoop3()
  Range("A1:A24") = Evaluate("IF(ROW(),CHAR(64+ROW(1:24)))")
End Sub

 

[VBA Geek]

for j = ASC("A")-64 to ASC("C")-64

 

[jonastjader]

Thats great,
thank you