View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NewUser22 NewUser22 is offline
external usenet poster
 
Posts: 7
Default Help with a "delete rows" Macro

Hey guys, can anyone help me with a macro I just cannot get worked
out. I have a simple "delete Blank rows" Macro, however the "Blank"
cell is just the result of an "IF" function that returns a "" or blank
cell. However the cell still holds the equation so it is not deleting
the rows, even though they are blank (just not technically). I would
like to know how I can get the macro below (or any other ideas you may
have) to delete all the rows that return a False calculation due to an
IF function, that uses columns A-G as the search method. I have copied
my current macro below.

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 4/20/2007 by fletchej
'
Columns("A:C").Select
Selection.SpecialCells(xlCellTypeBlanks).EntireRow .Delete
ActiveSheet.UsedRange

'
End Sub

Any explanation in a simplified form would be much appreciated,
sometimes I get lost in all the code.