How to delete rows in visual basic
 

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!

How to delete rows in visual basic
 

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

"Ruben" wrote:

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!

How to delete rows in visual basic
 

What was wrong with the previous suggestion?

--
__________________________________
HTH

Bob

"Ruben" wrote in message
...
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!

How to delete rows in visual basic
 

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


"Bob Phillips" wrote:

What was wrong with the previous suggestion?

--
__________________________________
HTH

Bob

"Ruben" wrote in message
...
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!