think i need an if statement 1

[thelos]

hello there
i have a column in a spread sheet in excel called "hours" if the hours are equal to zero i want to delete that entire row can someone please help

 

[xlbo]

Have you tried recording yourself deleting a row and see what code is produced ??

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[PHV]

Why not simply using an autofilter in this column and delete the visible rows ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886