Excel VBA Macro

How to Delete All Comments in Excel

This post will guide you how to delete all comments in your current worksheet in Excel. How do I delete all comments from a worksheet with VBA code in Excel. Delete All Comments with Delete Command Delete All Comments with Go To Special Feature Delete All Comments with VBA Delete All Comments with Delete Command… read more »

How to Change Column Width and Row Height in Excel

This post will guide you how to change the column width and row height for a given range in Excel. How do I resize Row height or column height for a range with VBA Macro in Excel. Change Column Width and Row Height with Format Command Change Column Width and Row Height with VBA Change… read more »

How to Compare Two Ranges with VBA in Excel

This post will guide you how to compare two ranges in one worksheet with VBA Macro code and highlight the cells that are different. How do I compare two ranges in two worksheets Using VBA in Excel. Compare Two Ranges with VBA Assuming that you have two lists of data in two worksheets, and you… read more »

How to Split Word into Different Cells in Excel

This post will guide you how to split word into different columns with a formula in Excel. How do I split word or number into separate cells with VBA Macro code in Excel 2010/1013/2016. Split Word into Different Cells with Formula Split Word into Different Cells with VBA Macro Split Word into Different Cells with… read more »

How to Extract URLs from Hyperlinks in Excel

This post will guide you how to extract URLs from hyperlinks using VBA Macro in Excel. How do I extract the actual addresses from hyperlinks in the selected range with a User Defined Function in Excel. Extract URLs from Hyperlinks with VBA Macro Extract URLs from Hyperlinks with User Defined Function Extract URLs from Hyperlinks… read more »

How to Remove Line Breaks (Carriage Returns) in Excel

This post will explain that how to remove line breaks in your data set in Excel. How do I remove carriage returns or line breaks with a formula in Excel. How to remove line breaks with VBA Macro in Excel. How to remove line breaks with find and Replace feature in Excel 2010/2013/2016. Remove Line… read more »

How to Select Every Other Row in Excel

This post will guide you how to select every other row with VBA macro in Excel. How do I select every nth row so that you can delete them in Excel. How to highlight every other row in Excel. Select Every Other Row Video: Select Every Other Row Select Every Other Row Assuming that you… read more »

Sidebar