VBA code to copy, move, delete and manage files

Automating processes with VBA can involve copying, moving, deleting and managing lots of files.  Thankfully, VBA has many built-in functions to undertake these tasks for us.  These files do not necessarily need to be Excel workbooks; they can be any file type. The filename for this post is 0041 VBA copy, move, delete and manage Read More

VBA to protect and unprotect Sheets

Protecting and unprotecting sheets is a common action for an Excel user.  There is nothing worse than when somebody, who doesn’t know what they’re doing, over types essential formulas and cell values.  It’s even worse when that person happens to be ourselves; all it takes is one accidental keypress, and suddenly the entire worksheet is Read More

How to add a prefix or suffix to every cell using VBA

We can often find spreadsheets with cells containing codes that have been shortened.  So, rather than Proj003412, the cell value has been reduced to just 3412.  It’s not a big problem to extend the code back to the full version; we could achieve that with a simple formula, then copy and paste special values.  If Read More