Noob here. 6 hours of searching and I'm still getting nowhere. I think this is very basic to some of you.

I have 100+ files in a folder. All files have the same format and sheets. What I need to do is to go to a specific sheet in all the files and encode a number to a specific range, save the file then exit.

I did experiment with the loop through all files in the folder and got it to work to open the file and save it however the number was not encoded.

Anyone can help? Thanks!

PS. The files in the folder have macro in them and the sheet where I need to encode to is hidden but not protected.