Hi LoriH,

Kindly help me, where I have to write this macro? I have same issue please
help me to write this macro.

Thanks

"LoriH" wrote:

This worked great. I was getting an error message at first but added a
msgbox to tell me when the files were all formatted and it went away. Thansk!

"LoriH" wrote:

I have an excel macro that I created to format a spreadsheet a certain way.
I want to run this macro on all the files in a specified folder. I am new to
macros and VBA. What is the easiest way to do this?

Thanks in advance!