Hi Terry,

Am Fri, 15 Dec 2017 08:48:11 +0000 schrieb Terry Pinnell:

Run-time error '5':
Invalid procedure call or argument

The line highlighted by Debug was this:

Set objFolder = FSO.getfolder(MyPath)

you can try the code in an empty sheet also.
But make sure you have the path in A1 (e.g.: G:\myvideos\)
Regard the backslash at the end of the path.
With the macro you don't need file names or hyperlinks in column F
because the code writes new hyperlinks for all files in the path's
folder and subfolders and the size in column G.

If you only want the size of the existing files in column F use Garry's
code.


Regards
Claus B.
--
Windows10
Office 2016