Hi !

Is anybody have an idea to get the total numbers of files of a folder. We have more than 20000 files in a folder and we want to check the total numbers of files exist in folders.

We have tried =ADIR() function to the same but it give an error "Invalid subscript reference" or "subscript out of range".


Thanks in advance
Ravi Mehrotra