montecarlo2012
Well-known Member
- Joined
- Jan 26, 2011
- Messages
- 984
- Office Version
- 2010
- Platform
- Windows
Hello.
I am trying to figure out how to loop with the chr. The idea is to populate an array with all the character with the start number on A1
with the little code I already have a problem with the data type, I am not sure, the fact is I was able to see only until 255, after that I got error, and now trying to fill all this array and do the looping job
I really don't know how to put the alt character into the loop, I would like to be able to write a number on Cell A1 for example 250000 and then get all the chr in the way I show in the ilustration.
thank you for reading this
Please some help.
VBA Code:
Sub Mr_Excel()
Dim x As Long
x = Range("A1").Value
ActiveCell.Value = Chr(x)
End Sub
I am trying to figure out how to loop with the chr. The idea is to populate an array with all the character with the start number on A1
with the little code I already have a problem with the data type, I am not sure, the fact is I was able to see only until 255, after that I got error, and now trying to fill all this array and do the looping job
I really don't know how to put the alt character into the loop, I would like to be able to write a number on Cell A1 for example 250000 and then get all the chr in the way I show in the ilustration.
thank you for reading this
Please some help.