Using a function to delete blank cells

[Guest]

Hi,

I hope I ask this in the right way: I have 4 column, 2,000 row sprdsht. I
want to instruct Excel to look in column B, and if any column is blank, then
delete it. In other words, out of all the records, I only want to see the
ones that have text in col B. Does anyone know of a formula/function that can
do that, or can you point me in the right direction?

Thanks,
Brian

 

[Guest]

a Function can't but a Macro can
so if u realy mean that every Row's where column B is empty is deleted then
try this:

Sub CleanUp()
Range("B1:B2000").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub


"Carter Devereaux" skrev:

 

[Gord Dibben]

No worksheet function can delete things, only return results.

I would try this.............

Select column B and F5>Special>Blanks>OK.

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP

On Fri, 31 Aug 2007 09:16:00 -0700, Carter Devereaux <Carter