I have a script which fills cells with exce.range.value function, but I have columns more than A-Z, how can I handle AA,AB, AC... columns???And I wrote:
Here is the script what I have:
excel.Range(chr(65+i) + str(excelrow), chr(65+i) + _
str(excelrow)).value = lstOrder.cell(i,1)
Re: I have a script which fills cells with ...
That does me, but for you I'd suggest adding a few more items to the Split(). After Z put in ",AA,AB,AC," etc until you have what you need. Then code your references in terms of numeric column and a row and let the function generate a meaningful address.
For example: (iCount in this case is the number of rows in an array I was committing to the spreadsheet.)