Retrieve min & max values from pivot filter/field

Hi all,

I have a pivot that I need to refresh every few days. Since the data keeps changing, I want the Macro to find the earliest and latest fiscal year in the pivotfield "Fiscal Year" automatically. How can I achieve that with code?

FY.PNG

I was in a rush and thought it was straight forward, apparently it is not

Here's what I've got so far:

Please Login or Register  to view this content.

My assumption currently is that there's a maximum of 2 fiscal years in the pivot field, though, this might change in the future, so I need to adjust the code to get the max and min for all values except "(blank)"...