Hi to all of you! Kindly require to provide me support so that a VBA would convert all formulas to its values in a folder which contains around 800 files and each file contains 4 sheets. I just want to convert the first sheet's formulas named "St. Issues" without open each file. In my personal opinion I think is a complicated code but I would much appreciated if someone could support me to resolve my project. Many thanks to all of you!