×

Ranges

Quickly Create A Dynamic Named Range in Excel

Quickly Create A Dynamic Named Range in Excel

What Is a Dynamic Named Range? A dynamic Named Range in Excel is a powerful feature that allows you to...

VBA Function To Validate Range Address

VBA Function To Validate Range Address

You Need To Check Your Cell Address Input A common task when using VBA with Excel is to validate cell...

VBA Code To Find Last Row Or Last Column (Best Way)

VBA Code To Find Last Row Or Last Column (Best Way)

Dynamic VBA Code With Last Row/Column Finding the Last Row or Last Column within your VBA code is key to...

VBA To Determine If Duplicates Exist In Range

VBA To Determine If Duplicates Exist In Range

What This VBA Code Does There may be instances where you need to ensure there are no duplicate values within...

Swap Two Selected Cell Ranges In Excel

Swap Two Selected Cell Ranges In Excel

What This VBA Code Does Often times when I am preparing spreadsheet reports, I find myself needing to perform minor...

VBA To Insert Zeroes Into Blank Cells

VBA To Insert Zeroes Into Blank Cells

What This VBA Code Does If you do any data loading to databases and prepare/clean that data in Excel, you...

VBA To Find All Cells That Are Blank/Empty

VBA To Find All Cells That Are Blank/Empty

What This VBA Code Does I’ve had numerous instances over the years when I have needed to target blank or...

Determine Height & Width of Selected Cell Range With Excel VBA

Determine Height & Width of Selected Cell Range With Excel VBA

What This VBA Code Does When creating dashboards you will want to try your best to keep your spacing even...

One Instance When Merging Cells Is Needed!

One Instance When Merging Cells Is Needed!

I am a HUGE advocate of not merging cells as they can cause all sorts of headaches while copying/pasting and...

VBA To Convert Named Ranges: Workbook To Worksheet Scope

VBA To Convert Named Ranges: Workbook To Worksheet Scope

What This VBA Code Does I had a project today that required me to change the scope of all my...

VBA To Check If Selected Cells Are Empty

VBA To Check If Selected Cells Are Empty

What This VBA Code Does Back in my early days of teaching myself how to write VBA, I found myself...

The VBA Guide To Named Ranges

The VBA Guide To Named Ranges

What Is A Named Range? Creating a named range allows you to refer to a cell or group of cells...

5 Ways to Create A Dynamic Auto-Adjusting VBA Range

5 Ways to Create A Dynamic Auto-Adjusting VBA Range

Dynamic Code Is Vital! A huge turning point for me when I was teaching myself how to write VBA was...