Find the column and delete the rows with value

[hudson andrew]

Hi all,

Can some one help me with the code that should search for the column " Data Orgin", column "Data orgin" will not be in same place or range everyday .

and filter the column and delete with the criteria "HRO".

if no criteria match code should end.

Thanks .

[KOKOSEK]

Try:

Please Login or Register  to view this content.

[sintek]

Another Option...

Please Login or Register  to view this content.

[hudson andrew]

Hi Thanks for this , but second method is throwing error " if we dont have HRO

"Run time error 91"

[sintek]

No errors for me with your file...See No HRO

[Marc L]

Hi sintek !

As it's an Excel table - VBA ListObject - it may not need to find the column just using the Excel table syntax …

[sintek]

Of course...Wasn't thinking Marc L...thanks for the heads up...

Please Login or Register  to view this content.