if not, and as stated it isn't, then you can use this
Sub Test()
Dim rng As Range
Set rng = Columns(1).SpecialCells(xlCellTypeBlanks)
Set rng = Intersect(rng.EntireRow, Range("A:B"))
rng.Delete shift:=xlShiftUp
End Sub
to just delete the cells in columns A and B where the cell in A is blank.
--
Regards,
Tom Ogilvy
"Dave Ramage" wrote in message
...
This should be about the quickest way, as long as it is
acceptable to delete the entire row. Select the cells in
column A then run it.
Sub Test()
Selection.SpecialCells(xlCellTypeBlanks).EntireRow .Delete
End Sub
Cheers,
Dave
-----Original Message-----
I need to write a macro to run through a list of values
in column A and
B.
If column A is blank, then I have to delete cells A and B
correspondingly.
Is it very difficult to do that?
---
Message posted from http://www.ExcelForum.com/
.