Re: Filtering macro fills a column of my sheet with #value error
This is a very clean and optimized code compared with mine. Thnx for your efforts pal. Especially I did like this part
As far as I understand from this code is, you simply search for "backups" string in the whole filename w/ its path to find out provided the opened file resides in the BACKUPS folder or not. Very clever method pal, really so smart!! You are saving my time and I really learn a lot from these snippets. Excel and VBA are both deep worlds and I like coding Excel for my needs.