Macro - refresh all not working for certain cells

Hi all,

I have a sheet that has a vlookup that references a date cell in the same sheet. The table array is on a different sheet. My macro opens the sheet, refreshes the sheet then closes it. I have other vlookups that reference words or numbers and they all work correctly. The date vlookup only works if I manually open the sheet with the table array.

Formula

=VLOOKUP(@$AF$55:$AF$60,'5.csv'!$A:$E,5,0)

Macro

Please Login or Register  to view this content.

I guess the issue sits with date formats, but I haven't figured it out.