Excel VBA Examples

How to Select Entire Column except Header Row in Excel

This post will guide you how to select entire column except header or first row in Excel 2013/2016. How do I select whole column except first header cell with VBA Macro in Excel. How to use shortcut keys to select entire column in Excel. Select Entire Column except Header Row with Shortcut Select Entire Column… read more »

How to Convert a String into a Formula in Excel

This post will guide you how to convert a string into a formula in Excel. How do I turn test strings to a formula for calculation. Convert a String into a Formula Assuming that you have a list of data in range C1:C4, which contains text string (Actually, they are all formulas, but they are… read more »

How to Copy Only Comments from Cells in Excel

This post will guide you how to copy only comments from a cell in Excel 2013/2016. How do I copy cell comments to another cell with VBA Macro in Excel. Copy Cell Comments with Paste Options Copy Cell Comments with VBA Copy Cell Comments with Paste Options To copy cell comments from a selected range… read more »

How to Get the Active Cell Address in Excel

This post will guide you how to get the active Cell address with a formula in Excel. How do I return address of active cell with a VBA Macro in Excel. Get the Active Cell Address with Formula Get the Active Cell Address with VBA Get the Active Cell Address with Formula If you want… read more »

How to Hide Rows with Zero Value in Excel (VBA)

This post will guide you how to hide rows with zero values in the selected range with VBA Macro in Excel. How do I hide rows which contain zero value in Excel. Hide Rows with Zero Value Assuming that you have a list of data in range A1:C5, in which contain sale values. And you… read more »

How to Remove Duplicates in One Cell in Excel

This post will guide you how to remove duplicate characters from a text string in one cell in Excel. How do I remove duplicate words from a cell with a User Defined Function in Excel 2013/2016. Remove Duplicate Characters Remove Duplicate Words Remove Duplicate Characters Assuming that you have a list of data in range… read more »

How to Sort Data by Last Character in Excel

This post will guide you how to sort cells by last character in Excel. How do I sort data by the last character with a formula in Excel. How to sort cells based on the last character with User Defined Function in Excel. Sorting Data by Last Character with Formula Sorting Data by Last Character… read more »

How to Change Multiple Hyperlinks in Excel

This post will guide you how to change multiple hyperlinks at once in Excel. How do I find and replace multiple link paths in multiple cells with Excel VBA macro. Change Multiple Hyperlinks At Once Assuming that you have a list of data in range B1:B5, in which contain multiple hyperlinks in those cell values…. read more »

How to Insert Blank Row based on Cell Value in Excel

This post will guide you how to insert a blank row below based on cell value in Excel. How do I auto insert row based on cell value with a VBA Macro in Excel. Insert Blank Row Below based on Cell Value Assuming that you have a list of data in range A1:B6, in which… read more »

Sidebar