How To Use VBA Dynamic Range In Excel

Oct 23, 2020

Below we will look at a program in Excel VBA that colors the maximum value of a dynamic range.

#Tutorial#How To#VBA#Range Object

How To Use VBA Select The Current Region In Excel

This example illustrates the CurrentRegion property in Excel VBA.

How To Use VBA Compare Ranges In Excel

Oct 22, 2020

Below we will look at a program in Excel VBA that compares randomly selected ranges and highlights cells that are unique.

How To Use VBA Entire Rows and Columns In Excel

Oct 21, 2020

This example teaches you how to select entire rows and columns in Excel VBA.

How To Use VBA From Active Cell to Last Entry In Excel

This example illustrates the End property of the Range object in Excel VBA.

How To Use VBA Range.Font property In Excel

The Font property of the Range object in Excel VBA gives access to a lot of other properties.

How to Use Possible Football Matches In Excel

Oct 18, 2020

Below we will look at a program in Excel VBA that shows a print preview of all the possible football matches from a list of teams.

How To Use The Offset VBA In Excel

The Offset property in Excel VBA takes the range which is a particular number of rows and columns away from a certain range (border below for illustration only).

How To Use Resize Property In Excel VBA

Oct 17, 2020

The Resize property in Excel VBA makes a range (border below for illustration only) a specific number of rows and columns larger or smaller.

Excel VBA - Union And Intersect

Oct 16, 2020

The Union method in Excel VBA returns a Range object that represents the union of two or more ranges (borders below for illustration only).