if you don't unfilter the range the end(xlup) part will only find the last visible cell-that's why the .autofilter line was added before finding the last cell in the code I supplied
if you don't unfilter the range the end(xlup) part will only find the last visible cell-that's why the .autofilter line was added before finding the last cell in the code I supplied
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks