Hi All.
I am trying to select the rows that contains the text "#N/A" on column N.
How do I do that?
My data are on columns B through columns N.
I am trying to select the rows that contains the text "#N/A" on column N.
How do I do that?
My data are on columns B through columns N.
Code:
Sub CutNA()
Dim FirstNA As Long, LastNA As Long
FirstNA = Columns("N").Find("#N/A", , xlValues, , xlRows, xlPrevious, , , False).Row + 1
LastNA = Cells(Rows.Count, "B").End(xlUp).Row
Rows("B"&FirstNA&":B"&LastNA).Select
Selection.Cut
...
End Sub