Filter between dates by cell dates instead of input

Please Login or Register  to view this content.

I am trying to set a cell value for the start and end date (C5 & C&) and have a macro filter the data in the chart by a Between Dates filter.

If i record the task, and change the dates to the sheet ranges, i get no filtering.

How can i accomplish this?

I have managed to solve this now.
I had to set the range as .text instead of .value.