Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to loop through the data in column A and if the text length of
the contents of the cell is not equal to 11 I want to delete the row. Here's what I have that is not working (error is function not compatible with object or something to that effect): For i = Range("A:A").Rows.Count To 1 Step -1 If WorksheetFunction.Len(Range("A:A").Rows(i)) < 11 Then Range("A:A").Rows(i).EntireRow.Delete End If Next i Can someone point out what I'm doing wrong, or suggest a better method? Thanks John Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text to column fixed length | Excel Discussion (Misc queries) | |||
Summing a column based on the length of text in a cell in anothercolumn | Excel Worksheet Functions | |||
Code to set text length in cell | Excel Programming | |||
Search a Column by text length | Excel Worksheet Functions | |||
The text length versus the cell size... | Excel Programming |