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.
XLOOKUP VLOOKUP macro alternative
This article will show how to write a macro alternative to the Excel functions of XLOOKUP and VLOOKUP. The macro will use variant arrays to lookup data.
Excel insert multiple rows & fill down
Our macro will insert and fill down rows of data simultaneously in a spreadsheet. This is useful where a financial model contains missing rows of data.
Goal: Enable users to insert and fill down multiple rows of data simultaneously in a spreadsheet.
How to freeze panes across selected Excel worksheets
This video will show you a macro-based solution to freeze selected worksheets in a workbook. As we presented in an earlier video (https://youtu.be/yyM2_KecErA), Excel will only allow a user to freeze panes in one worksheet at a time.
Goal: Allow Excel users to freeze panes in the same position, across selected worksheets in an active workbook.