Hello,
My problem is that my below Macro stops at “Set f3 = f1.SpecialCells(xlCellTypeBlanks)” because there are no non-Blank cells visible after the first Auto-Filter – but I still need to be able to add the name of the second pattern where those filtered cells were labelled by a previous Pattern eg. f = f & "//2ndUpStAfterWin". The entire Code I am using is below & I have attached the Starting Spreadsheet & the Desired Result (highlighted).
Is there any tweak I can make to this code so that it can cope with where there are no cells existing according to those Set f2 and set f3.
IF ELSE doesn’t work on my spreadsheets as they are very large (it stops halfway). Very keen to see what solutions may be and appreciate very much anyone's help.
Bookmarks