Excel - Go to Next Column

[litlmike]

Let's say that I want to loop the numbers 1 through 5, and on each iteration it should write to the next column in Excel.  So, I just want to put the number 1 in A1, 2 in B1, 3 in C1, 4 in D1, and 5 in D1.  How do I increase the column letter programamatically with the new Excel UDF?

Thanks!

For $iStartingColumn = 1 To 5
_Excel_RangeWrite($oWorkbook, Default, $iCC, $iStartingColumn & "1")
Next

[TheSaint]

The quick simple way.

For $i = 1 To 5
     iStartingColumn = Chr(64 + $i)
     _Excel_RangeWrite($oWorkbook, Default, $iCC, $iStartingColumn & "1")
Next

[water]

Put the numbers into a 2D array (1 row, 5 columns) and write the Array to A1 by calling _Excel_RangeWrite.

[litlmike]

  On 11/17/2014 at 5:24 AM, water said:

Put the numbers into a 2D array (1 row, 5 columns) and write the Array to A1 by calling _Excel_RangeWrite.

That is an elegant solution, and I don't know why I didn't think of that earlier.  In this particular case, it actually works better to use the CHR() because I am working with permutations, sets, etc.  But, I think the array works better in most other situations.

[water]

Choose the solution that best fits your needs