Many thanks for your reply. Are you able to write up a quick code to entirly replace this code, as I think I am stuck here. I just need to pull specific data ranges from 2 files that I will browse for, and then I will use the excel compare features. so I just need the code to broswse and pull specific (fixed) data ranges from the browsed for files. Your help is much appreciated.