Excel VBA Macro

How to Copy Value of Same cell From Multiple Worksheets in Excel

This post will guide you how to copy value from same cell on multiple worksheets in your workbook in Excel. How do I List values of same cell reference from multiple worksheets with a formula in Excel. How to copy data from the same cell of multiple worksheets with VBA Macro in Excel. How to… read more »

How to Protect or Unprotect Multiple Worksheets at Once in Excel

This post will guide you how to protect or unprotect multiple worksheets at once in Excel 2013/2016. How do I unprotect or protect all worksheet at the same time with VBA Macro in Excel. How to quickly unprotect multiple worksheets in Excel. Protect Multiple Worksheets at Once with VBA Macro Unprotect Multiple Worksheets at Once… read more »

Changing the Author Names for All Comments

This post will guide you how to change the Author name of the cell comments¬† in Excel. How do I quickly change the author names for all comments in your current Worksheet. How to change the author name in existing comments in Excel. Changing the Author Names for All Comments Assuming that you have lots… read more »

Insert Blank Rows when value Changes

This post will guide you how to insert blank rows when the value changes in Excel. How do I insert blank rows at every change in a Column in Excel. How to insert blank rows when value gets changed with VBA Macro in Excel. How to insert blank rows based on column value in Excel…. read more »

Replace Accented Characters

This post will guide you how to replace accented characters with regular letters in Excel. How do I use VBA Macro to replace accented characters in Excel. How to convert accented characters quickly with VBA Macro quickly in Excel. Replace Accented Characters Assuming that you have a very large text data which contains accented characters… read more »

Insert Character or Text to Cells

This post will guide you how to insert character or text in middle of cells in Excel. How do I add text string or character to each cell of a column or range with a formula in Excel. How to add text to the beginning of all selected cells in Excel. How to add character… read more »

Auto Highlight Active Row and Column

This post will guide you how to highlight the active row and column in Excel. How do I highlight row and column of active cell with Excel VBA Macro. How to highlight the active row or column when a cell is selected. Auto Highlight Row or Column of Active Cell When you select one cell… read more »

Swap Contents of Two Cells in Excel

This post will guide you how to swap contents of two cells in Excel. How do I swap cell contents with VBA Macro code in Excel. how to swap values between two cells in Excel. Swap Contents of Two Cells You can use a VBA Macro code to quickly swap contents of two selected cells… read more »

Rename Multiple Worksheets in Excel

This post will guide you how to rename multiple worksheets in your current workbook in Excel. How do I rename multiple worksheets at one time in Excel 2013/2016. How to rename one or multiple worksheet tabs in Excel. Rename Multiple Worksheets You can rename multiple worksheets manually by the following steps: #1 select one worksheet… read more »

Remove Trailing Spaces from Cells in Excel

This post will guide you how to remove leading and trailing spaces in cells in Excel. How do I remove leading or trailing spaces in a range of cells with a formula in Excel. How to remove trailing spaces from cells with VBA Macro in Excel. Remove Trailing Spaces from Cells with Formula If you… read more »

Sidebar