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.
Loop through rows in a column in Excel VBA
This feature will show you how to write a simple loop of columns in a row. We will compose a simple looping macro based on a basic parameter.
Goal: Demonstrate to Excel users how to write a basic looping macro through rows in a column.
Loop across columns in a row in Excel VBA
This tutorial will walk you through a simple loop of columns in a row. We will show how to write a simple looping macro based on a simple parameter.
Goal: Show Excel users how to compose a simple looping macro across columns in a row.
Excel VBA Dynamic Row Ranges
This video will demonstrate how to write an Excel VBA macro, which will dynamically select a data range based on changing rows of data.
Goal: Create a macro to select dynamically changing rows ranges of Excel spreadsheet data.