Hi,

I am having a problem with the following loop...


      

For iCol = 65 To (sTotalCols + 64)
           sCol = Chr(iCol)
Next
The problem is that if the spreadsheet has a column "AA" then it returns sCol as "]", when I need it to return "AA"

Thanks

Stephen