Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bubble sort Error (Compile Error: Type Mismtach) | Excel Programming | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming |