Hi. Today’s video will show you how to delete rows of data based on cell errors across worksheets. As we can see, some of the…
Automatically highlight the active row in Excel
Goal: To write a simple worksheet macro event, which will highlight the active row that our cursor is on. Download Spreadsheet Vault SpreadsheetVault – Highlight…
Excel VBA Dynamic Ranges in a Pivot Table
Goal: A macro to allow Excel users to dynamically update a change source data range in a Pivot Table. This tutorial will explore one way…
How to convert formulas to values in an Excel workbook
Goal: To convert all formula cells contained in a workbook to their cell values using an Excel macro. This presentation will show you how to…
Create index with hyperlinks to selected sheets using Excel VBA
Goal: To create a table of contents of hyperlinks to selected sheets using Excel VBA Hi there, this feature is a follow-on to an earlier…
How to unfreeze panes across selected Excel worksheets
This feature will present a macro approach to unfreeze selected worksheets. Currently Excel only allows users to unfreeze panes one worksheet at a time.
Goal: Permit Excel users to unfreeze panes across selected worksheets in an active workbook.