Hi again... autofilter does not work because of all the empty spaces in the column, it just finds blanks underneath... is there any way a loop through the column can work?