Hi,
I have string like this.. built from "&" and the output is 'G:\Crush\Daily plant reports\2019\[05-2019.xls]C vol'!$F$35. When I use the named variable as Eval=IF(NOW(),EVALUATE('G:\Crush\Daily plant reports\2019\[05-2019.xls]C vol'!$F$35)) and I call this named variable in another cell =Eval then I get #REF error.
I wrote the VBA function as
And calling this function in a cell as myEvaluate('G:\Crush\Daily plant reports\2019\[05-2019.xls]C vol'!$F$35) it gives me #VALUE error.Please Login or Register to view this content.
Any help?
Bookmarks