Hi,

A very quick question regarding DirList(). I seem to recall the instructions for this UDF state that it will return an empty string if no files matching the file mask are found. How do you check for this? Also, say for instance I am trying to find the number of *.XLS files in a folder, I will use the UBOUND function on the array that DirList returns to tell me how many there were. Obviously this number is always 1 less than the 'true' number as arrays are counted from zero upwards. If there is only 1 file then the answer is 0. The answer is still zero if there are zero files found though it seems.... can anyone help?

Thanks