I have juts tried it again and it worked fine/

The line before that defines the directory to scan. I set to E:, and you
probably don't have an E: drive. Did you change it?

--
HTH

Bob Phillips

"shfcook" wrote in
message ...

blimey, thank you. I have tried running this and it's coming up

Compile error:
Invalid Redim

on line:

"ReDim Preserve arfiles(2, cnt)"

I'm not that brilliant at VBA obviously so am I bit stuck, any more
help would be much appreciated!


--
shfcook
------------------------------------------------------------------------
shfcook's Profile:
http://www.excelforum.com/member.php...o&userid=27169
View this thread: http://www.excelforum.com/showthread...hreadid=467459