Array VBA Filter

Hi ill mark our your problems here.................I had problems using the arrow sign so i just used text (lessthansign)

Please Login or Register  to view this content.

so first, you declared 'ft_Date' as a 'Date'......this is not an array..........and you dont really need to use an array here just a string

Change it to this

Please Login or Register  to view this content.

Next
you can put those next 2 lines into 1, just change it a little, lets also convert the last_two_month to a Long so the date becomes a number. why, because excel just stores dates as numbers so this will make sure we get something excel understands

Please Login or Register  to view this content.

Next

Please Login or Register  to view this content.

and that should do it, you can add those extra parts to the last code if you like but its not needed here