After giving some more thought to this problem I think this might be relevant.
There are other macros that I run to delete unwanted data. A sample is
Code:
Sub DELData()
'
' DELData Macro
'
'
Sheets("Sheet1").Select
Application.CutCopyMode = False
Selection.Copy
Cells.Replace What:="Sample Text", Replacement:="", LookAt _
:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Sheets("Control").Select
End Sub
I used this in another workbook to do the exact same thing. This worked fine in the other book. Now it seems that even though it is replacing the data to "" there is still something lingering. The rows that are not being deleted by the macro posted in my first post are all rows that have text replaced