Slohcin

That's what happen here. Are you sure A,B and C are empty? No formula, or
similar?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Slohcin" wrote in message
...
Nick,
Thanks for your reply.
I have tried what you suggested, but nothing happens. I was expecting an
"x"
in column E, but get nothing. What am I doing wrong?
--
Thanks
Slohcin


"Nick Hodge" wrote:

Slohcin

I would set up a helper column in E and enter

=IF(AND(B1="",C1="",D1=""),"x","")

Then copy down and sort on that column and delete all the rows with an x
in

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Slohcin" wrote in message
...
I need to delete rows when certain columns have empty cells.
ColA ColB ColC ColD
data y y
data
data y y
data y y y

What I need to do is delete row2 because columns B,C & D are empty.

How can I do this?
--
Thanks
Slohcin