jonathann3891
Board Regular
- Joined
- Apr 27, 2015
- Messages
- 109
I have this bit of code that will find and replace text
Is there anyway to make it start searching after A5?
I have two statements that are exactly the same. The one in A5 needs to stay put, the other one needs to be deleted.
Code:
Columns("A").Replace "*section*", "#N/A", xlPart
Columns("A").Replace "*show*", "#N/A", xlPart
On Error Resume Next
Columns("A").SpecialCells(xlConstants, xlErrors).EntireRow.Delete
On Error GoTo 0
Is there anyway to make it start searching after A5?
I have two statements that are exactly the same. The one in A5 needs to stay put, the other one needs to be deleted.
Last edited: