MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


How to change the macro so it writes the data to the active cell rather than a named one.

How to get a macro to run automatically when the user opens a workbook.

How to eliminate slashes from file names when saving with macro.

Is it possible to change a cell value without changing the formula?

I just want to know if there is a way to delete decimal point in the amount thus converting it to text.

Some other basic Excel tips to make your life easier.

A small list of Excel Keyboard Shortcuts to make your life a little easier.

Conditional formatting allows for 3 conditions. By setting up conditions correctly, you can really allow for 4 conditions when the default formatting of the cell is considered.

VLOOKUP is a powerful tool. Sometimes, if an exact match is not found, a value other than the standard #N/A is desirable.

How to change the case globally so that it is properly formatted.

Is there a way to remove multiple hyperlinks?

How to count cells by interior color using VBA.

How to split the contents of a cell in to columns.

How to eliminate "Enable Macros" message box.

How to examine a range of cells and return a certain value if any one of the cells in the range contains a certain word.

How to calculate and display the largest value.

How to automatically add a character in a cell.

How to have IF function to return Yes or No.

How to close a workbook without saving it by using VBA.

How to create and name a new worksheet with Visual Basic for Applications - VBA