crmpicco

I am having a problem with my ASCII conversion and having these values inside a loop.

The values start out below as:

tempCol = 67 (which is the ASCII value for 'C')
iTotalCols = 46 (which is the number of columns I have in the sheet)
iColour is just a Integer

The problem i am experiancing is that when the loop gets to 91, which is [ (left/opening bracket) - i get an error.

How can i stop this?



I have this loop structure:


For n = tempCol To iTotalCols + 64
sRange = Chr(n) & m
If Trim$(Range(sRange).Text) <> "" Then
Range(sRange).Interior.ColorIndex = iColour
End If
Next n



Thanks.

Picco