How to delete rows in visual basic

R

Ruben

Hello,
I would like to delete rows for a specific criteria in visual basic, but I
don't know how. I have filtered my data, and now I would like to delete the
data that did not pass the filter. Thanks for helping!
 
A

akphidelt

I think its the EntireRow.Delete that you can use

So you can loop through your data, and any criteria that doesn't match put

Range("WhateverCell").EntireRow.Delete
 
R

Ruben

Bob,

Sorry for my very late reaction. I used your first suggestion for
autofiltering and deleting the rows, which works well. I think I have posted
the question twice, so there was nothing wrong with your first post. Thank
you very much for helping me!

Ruben
 

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

Macro to select and delete levels of a document 2
Data filter and deleting rows in visual basic 0
Filtered view of Visio Chart 0
How to delete rows in visual basic 3
Link a text box based on drop down box with four options MS Word 365 0
How to clear prior search terms from Navigation Pane 0
Dealing with the error: unable to filter on excel hc home school 0
Working outlook via vba code with xlsx - error 0

Top