>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

I just tried

?ADir(dummy,'mypath\*.*')

with a directory with more than 54000 files. Worked fine.