Hi all,
I can't work out for the life of me why this simple code isn't working.
Any suggestions?
Just rying to filter between the two named range dates set at the beginning of the code.
Please Login or Register to view this content.
Hi all,
I can't work out for the life of me why this simple code isn't working.
Any suggestions?
Just rying to filter between the two named range dates set at the beginning of the code.
Please Login or Register to view this content.
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi AlphaFrog,
I am getting a compile error: object required.
I have removed the "set' at the beginning and now the code is running.
It is behaving strangely however, the filter is returning 0 results until I go into the filter again and run the settings already in the filter. Additionally it is applying dates in the named range in an American date format. The format I am using is dd/mm/yyyy.
Do you run into problems like this often with different date formats?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks