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