EXCEL Question

Does anybody know how I could identify the number of charcters within each cell of a spreadsheet. There is over 700 lines of information but I need to know whether any cells have over 30 characters within them.

Cheers

[LSainsbury]

GOOGLE is your friend!!!

USE IT!!!!

[gazzae]

Off the top of my head

Set w = Worksheets("sheet1")
Set r = w.Range(w.Cells(5, 1), w.Cells(50, 10))

For Each i In r
    If Len(i.Value) > 30 Then
        MsgBox "Blah"
    End If

Next

You can then replace the message box with what you want to do with the cells over 30.

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.

[gazzae]

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.