Check if a list of Files exists Macro

Hi all,

I have a list of file paths in excel and want to use a macro to check if that actual files exists. I have it working where i can manually check the selected cell. However, i want to know if its possible to check the whole list in the one go - and for it to write the result in column A - either YES or NO.

I have attached what i've got so far - any help would be greatly appreciated.

Thanks,
C