VBA Output to Excel Using the Range command with the Chr() function 1

[dougez]

I am trying to determine how the following code determines where to put the output in an excel spread sheet. The VBA code is written:

j=68        
Range(Chr(j) + "22").Select
ActiveCell = G / 1000

I don't understand how the values inside the parentheses following "Range" designate the cell for "G/1000" to be returned in.

The output is in a do-while loop, and the character "j" increments by 1 each time, I am assuming to put the output in a cell one column over(?)after each loop.

Thanks for any help!

 

[mike777]

(Look in MS Access Help for the "Chr" function.)
Chr(68)="D"
Chr(69)="E"
Chr(70)="F"
Chr(80)="G"
etc.
Hope this helps.
-Mike