Find cell value and return even number on adjacent cell

Hi Friends:

I need a small macro that will check D15 value in the active worksheet (sheet1), and if the number (n) is odd, then return (n-1) value in E15 cell. Since I want to do this to all files in a folder, I would appreciate a macro, not just a formula. Thanks.

Try this

Please Login or Register  to view this content.

You will need to adjust the path for the MyFolder variable.

Thank you mrice and Cutter for your codes. They both are working exceedingly well.