Compile Error
Hi. Maybe not correct, but perhaps some ideas...
Sub Demo()
Dim MyRange As Range
Dim S As String
Set MyRange = ActiveSheet.Range(Selection, Selection.End(xlUp))
For Each Cell In MyRange.Cells
S = Left$(Cell.Value, 5)
Select Case S
Case "GL Op", "Au Op", "WC Op", "CA Op"
Cell = S
End Select
Next Cell
End Sub
= = = = =
HTH :)
Dana DeLouis
mypetduke wrote:
I have the following code and keep getting a Compile error: For without Next.
Can anyone help.
Set myrange = ActiveSheet.Range(Selection, Selection.End(xlUp))
For Each cell In myrange
If Left(cell.Value, 5) = "GL Op" Then
cell.Cut
cell.Paste ("GL Op")
End If
If Left(cell.Value, 5) = "Au Op" Then
cell.Cut
cell.Paste ("Au Op")
End If
If Left(cell.Value, 5) = "WC Op" Then
cell.Cut
cell.Paste ("WC Op")
End If
If Left(cell.Value, 5) = "CA Op" Then
cell.Cut
cell.Paste ("Au Op")
End If
End Sub
|