How to auto run a VBA macro whenever Ms Excel or Ms Project starts
This is how you can set the VB macro to auto run whenever Ms Excel or Ms Project starts.
Posts
How to save file and automatically overwrite an existing file without prompt in VBA macro
This is how to run the FileSaveAs command in VBA macro which is commonly used in Ms Excel or Ms Project without having the application prompt for overwriting and existing file.
How to save as a new file extension using the same current filename in VBA macro
This is how you can save as a new file with a different file extension but the you would like to use back the same file name as the current file you are saving from. This is a VBA macro code for Ms Excel, Ms Project or any other Ms Office product that uses VBA macro for automation.
Autofill empty cells with content from the first cell above the empty cells in Microsoft Excel
Non Macro Solution Select the first cell that have the content that need to be paste to the empty cells. Scroll down to the last empty cells below the first cell that needed to be fill. Hold shift and select the last cell. Ctrl + D Macro Solution