Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complie error: can't find project or library
Hi, the "left" is creating error. I am trying to delete "cu" if it represents
the first two characters in the cell. Sub Step8_CleanUpAllSheet() Dim r As Integer For r = Cells(65536, 4).End(xlUp).Row To 2 Step -1 If Left(Cells(r, 4), 2) = "cu" Then Cells(r, 4).TextToColumns Destination:=Cells(r, 4), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 9), Array(2, 1)), TrailingMinusNumbers:=True End If Next r End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compile error: Can't find project or library | New Users to Excel | |||
Can't Find Project or Library Error | Excel Discussion (Misc queries) | |||
can't find project or library - error | New Users to Excel | |||
Error:Can't find project or library | Excel Programming | |||
Comple Error Cannot Find Project or Library | Excel Programming |