delete row if k is empty

[hktom]

Dear all,

attached with file.

Our vba code run " delete row if k is empty "

when we apply vba code in sheet1, we need to press 4 times button.
Then we get the answer. Actually we should press 1 time button to run.
Then sheet 1 should become sheet named "answer"

please help
Thanks
Tom

[sweep]

Hi,

Does this code help you?

Please Login or Register  to view this content.

[hktom]

Great it solve with thanks

[davsth]

If this is the way you want to do it. (Filtering can be a quicker option), you need to delete from the bottom of the file, rather than the top (its simpler that way with the counting of the row

Please Login or Register  to view this content.

[hktom]

Thanks Davsth