Recent content by gbloemke

Thanks to PHV as well!

[smile]Skip, you're my new hero. It all works, and I learned a lot as well. Thanks and have a great weekend. Greg

Okay Skip, that was awesome? It worked! You just showed me a new way to do this, and I will remember the whole "With ActiveSheet.UsedRange" simplier thought process for my next code! Thank you. Question, after this code runs, I get a pop-up dialog box that says "Delete entire sheet row?" and...

I am sorry, I mispoke. This code works fine for filtering the data. I want to delete all rows that meet the filter criteria. It's the code that comes next that I am struggling.

I use Excel 2010. I run VBA code on this one table everyday. I currently have to do it partly manually, because it deletes more rows than I want it to. My goal is to filter the spreadsheet using this criteria: Filter column 22 = "NEP", also filter column 16 = "Groom". Then, I wish to delete...

Sometimes, the answer is simple and right under my nose. You were right Skip. I was thinking far too complicated about VBA code on this one. Back to basics for me. Thank you, Greg

I have a spreadsheet with 7000 lines of data. I want to delete certain rows of data that meet criteria. I need to filter column V to see only a criteria of "NEP". I then want to filter column P to see only a criteria of "Groom". I then want to filter column G to see only a criteria of "ONSP*"...

Mintjulet, that link helped a lot. That, along with the post from zelgar, solved my issue. Thanks. I was able to find what I needed.

I have created a worksheet that shows dates in 2013 in Column A. I need VBA code that will subtract 3 days from that date and put the new date in Column B (this is a simple subtraction formula that I have already created). However, the tricky part is that if that new date falls on a Saturday...

Skip, that worked great, and it was so soo simple! Thank you, Greg

I have this VBA code to add/remove the autofilters, but it toggles back and forth, meaning that when I run it the first time, it adds autofilters, when I run the code again, it removes it, run it again, it adds it again, and so on. I want this code to only remove the autofilter from the...