Hello everyone!


I'm trying to use the functions in the tutorial on this page on my version of Excel for mac (2019)


What I would like to be able to achieve is the same thing: I have file names in a column, I would like to search if they are present in a folder and its subfolders and if yes, report the path to the file.


I replaced the characters "" with "/" (used by mac).

Next the first error I get is on
ReDim temp(0)
in first function. The error is "Wrong number of dimensions"