The following code has to search a column to determine if first letter is a number. if not then replace cells preceeded by O,o,l and blanks by 0,0,1 and blank space removed respectively. and delete other cells.
it is giving run time error 424: object required.
how do i make this code to search the entire worksheet? and also remove space in between numbers??
Sub Testing1()
Dim i As Integer
Dim ch As Characters
For Each num In Range("A2:A10")
Set ch = Left(num, 1)
If Not (IsNumeric(ch)) Then
num.Font.ColorIndex = 11
num.Interior.ColorIndex = 2
Select Case ch
Case "O", "o"
left(num,1)= "0"
num.Interior.ColorIndex = 3
Case "l"
left(num,1)= "1"
num.Interior.ColorIndex = 3
Case " "
left(num,1)= ""
num.Interior.ColorIndex = 3
End Select
End If
Next num
End Sub
Bookmarks