I need to filter a column removing blank entries, then select the cell(s) left. I used the code below to select the cells with multiple entries left, the problem is that when I only have one entry, the macro ctrl+shifts down with no end cell. I'm not sure If I Need some kind of count variable or just an if statement, but any help is appreciated.
Please Login or Register to view this content.
Bookmarks