Need help deleting filtered data only within a range in vba

[lilsnoop]

Greetings,

I was hoping someone could suggest some vba coding which would delete filtered data only excluding the header row, which would have a range of Column A through AI. I have data in cells past AI that I wouldn't want deleted and thus any cells deleted would have to bring the cells below them (not filtered) up after the filtered data is deleted. Hope that makes sense.

I've attached a small sample workbook, which also gives a little explanation of what I'm trying to accomplish as an example.

Thanks for any suggestions in this request!

[AlphaFrog]

Please Login or Register  to view this content.

[Fluff13]

I think that with filtered ranges you can only delete the entire row, how about this instead

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.

[lilsnoop]

Hello AlphaFrog Thank you for tackling this problem. Your code works perfect deleting the filtered data, but it is also deleting data beyond the AI column for that same deleted row of filtered data.

[lilsnoop]

Fluff13 - Thank you! That code does exactly what I need!
Really appreciate everyone's assistance!

Carl

[sintek]

Just out of curiosity...I am assuming you made use of the provided code with your actual code...
Does post 4 not justify a response...

[Fluff13]

You're welcome & thanks for the feedback

[sintek]

@ Fluff13

I think that with filtered ranges you can only delete the entire row

Just in case you missed it...Post 4 allows for this...

[Fluff13]

Agreed & didn't think of doing it like that, but in this instance it also destroys some of the formulae in col AJ

[sintek]

True...however the range just needs to be extended to include AJ...OP just needed to explain his required output in more detail...

[lilsnoop]

Sintek,

Your coding worked well too! Thank you for taking the time to help, it was much appreciated!