yoitsmejy
06-21-2011, 06:18 AM
Hi guys,
I am trying to move whatever is in column C to column B if it does not contain "123123". I am having problem on writing the macro. I think the best way is using offset, but i am not experience with using offset and therefore it have some error. Please help me with the code or if you have any suggestion that will make it more faster and efficient. Thanks.
With ws.Cells(Lrow, "C")
If Not IsError(.Value) Then
If .Value = "123123" Then .ClearContents
If Not .Value = "123123" Then ActiveCell.Offset(0, -1).Select
End If
End With
I am trying to move whatever is in column C to column B if it does not contain "123123". I am having problem on writing the macro. I think the best way is using offset, but i am not experience with using offset and therefore it have some error. Please help me with the code or if you have any suggestion that will make it more faster and efficient. Thanks.
With ws.Cells(Lrow, "C")
If Not IsError(.Value) Then
If .Value = "123123" Then .ClearContents
If Not .Value = "123123" Then ActiveCell.Offset(0, -1).Select
End If
End With