Excel VBA Examples

How to Vlookup to Return Multiple Values in Excel

This post will guide you how to vlookup to return multiple values in one cell in Excel. How do I lookup and return multiple values concatenated into one cell with an User defined function in Excel. Vlookup to Return Multiple Values in One Cell Assuming that you have a list of data in range A1:B6,… 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 »

How to Sum Range Ignoring Errors in Excel

This post will guide you how to sum range of cells ignoring Errors in Excel. How do I sum and ignore errors with a formula in Excel. How to sum range ignoring all error values with VBA macro in Excel. Sum Range Ignoring Errors with Formula Sum Range Ignoring Errors with VBA Sum Range Ignoring… read more »

How to Replace Formulas with Their Values in Excel

This post will guide you how to replace formulas with their calculated values in Excel. How do I replace all formulas with their values using VBA Macro in Excel. Replace Formulas with Their Values Replace Formulas with Their Values Using VBA Assuming that you have a list of data that contain formulas in range B1:B4,… read more »

How to Import Data from another Workbook in Excel

This post will guide you how to import data from another workbook into your current worksheet in Excel. How do I copy data from a closed workbook with VBA Macro in Excel. How to insert worksheet from closed workbook into the current workbook in Excel 2013/2016. Import Data From Another Workbook Import Data From Another… read more »

How to Transpose Rows and Columns in Excel

This post will guide you how to convert row data to columns in Excel. How do I convert columns to rows with Paste feature in Excel 2013/2016. Convert Rows to Columns Using Paste Special Convert Rows to Columns Using Formula Convert Rows to Columns Using VBA Convert Rows to Columns Using Paste Special Assuming that… read more »

Sidebar