DELETE ROE???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way possible to delete a ROW if a specific
CELL = 0; I don't want to hide it. Any help would be
appreciated.
 
try this in a macro
if range("a1")=0 then range("a1").entirerow.delete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop Within Loop... Sometimes 2
Count within class 3
loop code on cell range 1
How can i hide a row or delete 4
Hide and Show Rows based on Cell Value 2
hiding or showing rows based on a cell value 6
Easiest Way to Delete Rows 4
Deleting Rows - only deletes content 2

Back
Top