Originally Posted by NEONKNIGHT
Thanks for the replys. I've found a way by adding in an extra column to the data I want to count if you put in =LEN(Cell Ref)
this gives you the total charcters in that cell.
That way would be the best if its only one column where cells will have over 30 characters.
The code way is the best if you have any number of columns in a range where cells could have over 30 characters. You could use i.Interior.ColorIndex = 3 to mark each cell over 30 characters red.