Excel VBA Examples

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 »

How to Count Cells That Contain Specific Text in Excel

This post will guide you how to count cells that contain specific text in Excel. How do I count cells with text and characters using a formula in Excel. How to count cells with specific text value using VBA Macro in Excel. Count Cells with Specific Text using Formula Count Cells with Specific Text using… read more »

How to Find Most Common Value in a Range in Excel

This post will guide you how to find the most common value in a column of data in Excel. How do I find the most frequently occurring text from a list with array formula in Excel. How to extract the most frequent value from a list of data with VBA Macro in Excel. Find Most… read more »

How to Split Comma separated Values into Columns or Rows in Excel

This post will guide you how to separate comma delimited cells to new rows or columns in Excel. How do I split comma separated values into rows with Text to Column Feature in Excel. How to convert comma separated text into rows or columns with VBA Macro in Excel. Split Comma Separated Values into Rows… read more »

How to Print Long Column on One Page in Excel

This post will guide you how to print long columns of data into one page in Excel. How do I split one long column into multiple smaller columns so that you can print it in one page in Excel. Print Long Column on One Page If you want to print one long column into one… read more »

How to Reverse the Order of Rows in Excel

This post will guide you how to reverse order of rows in Excel. How do I flip data in rows with VBA Macro in Excel. Is there any simple way to reverse the order of some rows in Excel. Reverse the Order of Rows Assuming that you have a list of data in range A1:D2,… read more »

Sidebar