Row Looks to be blank but its not

bremen22 · #2 01-28-2014, 03:50 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
won't show blank cell	bhum	Excel	2	01-28-2014 02:34 AM
Document comes up as a blank	Grover	Word	1	11-29-2013 07:24 PM
Page numberring 1 - blank - 2 - blank etc	Intern	PowerPoint	0	09-02-2011 01:16 AM
hidden blank pages	mljm	Word	3	06-19-2009 03:18 AM
How to turn all blank lines into non-blank for legal forms	sieler	Word	3	04-12-2009 01:38 PM