Excel VBA Macro

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 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 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 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 »

How to Convert Multiple Rows into a Single Row in Excel

This post will guide you how to convert multiple rows or columns into a single row with a formula in Excel 3013/2016. How do I convert groups of rows to a single row of columns with VBA Macro in Excel. Convert Multiple Row into Single Row with Formula Convert Multiple Row into Single Row with… read more »

How to Hide Rows Based on a Cell Value in Excel

This post will guide you how to hide rows based on cell value in Excel. How do I hide rows based on cell value with VBA Macro code in Excel 2013/2016. Hide Rows Based on Cell Value using Filter Feature Hide Rows Based on Cell Value using VBA Macro Hide Rows Based on Cell Value… read more »

How to Delete All Textboxes in Excel

This post will guide you how to delete all textboxes from an active worksheet in Excel. How do I delete all textboxes without looping using an Excel VBA Macro. How to delete multiple text boxes in Excel. Delete All Textboxes Using Go To Special Feature Delete All Textboxes Using VBA Macro Delete All Textboxes Using… read more »

Sidebar