Excel VBA Examples

How to Deselect Cells from Selected Range with VBA

This post will guide you how to deselect cells from a selected range of cells in your worksheet. How do I quickly deselect cells from a selected range of cells with VBA code in Excel. Deselect Cells from Selected Range with VBA Video: Deselect Cells from Selected Range with VBA Normally, if you want to… read more »

How to Sum Only Filtered Data or Visible Cell Values in Excel

This post will guide you how to sum only visible cell values in Excel. How do I sum only visible cell values in a selected range with a formula in Excel. How to sum only visible rows when filtering data in your worksheet with VBA code in Excel. Sum Filtered Data Only with Formula Sum… read more »

How to Round a Range of Cells in Excel

This post will guide you how to round a range of cells with a formula in Excel. How do I round a range of cells using VBA macro in Excel 2013/2016. How to round up a range of numbers in a column in Excel. Round a Range of Cells with ROUND Function Round a Range… read more »

How to Count And Sum Cells by Color in Excel

This post will guide you how to count and sum cells by font color or cell color in Excel. How do I sum cell values by font color with VBA code in Excel. How to sum cells by color with formula in Excel. Sum Cells by Cell Color with Filter feature Sum Cells by Cell… read more »

How to Hide and Unhide Horizontal and Vertical Scroll Bar in Excel

This post will guide you how to hide or unhide horizontal and vertical scroll bar in your current worksheet in Excel. How do I control Display of the Scroll Bars in Microsoft Excel 2013/2016. Hide and Unhide Horizontal and Vertical Scroll Bar with Excel Options Hide and Unhide Horizontal and Vertical Scroll Bar with VBA… read more »

How to Delete All Visible Rows in Excel

This post will guide you how to delete all visible rows or columns in Excel. How do I select only the visible cells in Excel 2013/2016. How to delete only visible rows without the hidden rows in Excel. Delete Visible Rows with Go To Special Feature Delete Visible Rows with VBA Macro Video: Delete Visible… read more »

How to Resize All Selected Pictures to Fit Cells in Excel

This post will guide you how to resize all selected pictures to fit cell size with VBA Macro in Excel. How do I resize multiple pictures to cell size in Excel. Resize Multiple Pictures to Fit Cell Size Video: Resize Pictures to Fit Cell Size Resize Multiple Pictures to Fit Cell Size Assuming that you… read more »

How to Count the Number of Sheets in a Workbook

This post will guide you how to count the number of sheets in a workbook in Excel. How do I count the number of worksheets in a workbook with VBA Macro in Excel. Count the Number of Sheets with Define Name Count the Number of Sheets with VBA Macro Video: Count the Number of Sheets… read more »

How to Insert Multiple Images at Once in Excel

This post will guide you how to insert multiple images at once in Microsoft Excel. How do I quickly insert multiple pictures into Excel Cells with VBA Macro. How to insert multiple pictures and resize them in Excel. Insert Multiple Images At Once Assuming that you want to insert multiple images from a folder at… read more »

How to Add Values in Multiple Selected Cells in Excel

This post will guide you how to add a specific value in a range of cells in Excel. How do add a number for all values in multiple cells with VBA Macro in Excel. Add Values in Multiple Selected Cells Video: Add Values in Multiple Selected Cells Add Values in Multiple Selected Cells Assuming that… read more »

Sidebar