VBA Code To Find And Replace Words Within Specific File Names In A Folder

VBA Code To Find And Replace Words Within Specific File Names In A Folder

I often have a routine of copying files from one month to another. The only problem with this sort of process is I have to go through and modify all the file names to reflect the current month or time period. As you can imagine, this can be quite a timely task....and timely tasks are perfect for automation with VBA!

Read More

VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

When you are trying to understand an unfamiliar workbook or Excel model, it can immensely help knowing which tabs are feeding into the one you are currently viewing. This little macro will give you a message box indicating any outside worksheet references found in the cell formulas of the ActiveSheet. 

Read More