vba autofilter macro

Hi I've recorded a macro which filters blanks in a sheet. However, I need to modify it, so that it deletes the blanks from the range in the sheet regardless of the number of rows. Does anyone know how to modify the code below, please? Also, is there a good tutorial on VBA autofilters that...

Hi everyone, I am new here and new to VBA as well. I want to create an auto filter code that will delete rows based on criteria. I need to delete rows of one criteria in one column and then another criteria in a different column. I have the following code that will cover one criteria but I...

Hi Everyone, I am getting the weirdest thing happen to me when I try and run a code. When I run it via "step into" and hold down F8, everything works perfectly. When I just hit run and it does it (way faster), it skips deleting out columns in my autofilter function. I've tried everything...

Firstly, i apologize if the title doesn't quite match my request i was unsure of how to word it or if in the wrong place or anything (1st post) I use an excel sheet to assign work to 5 individuals and on certain days this involves me pasting someones name 100 times and so forth. I was...