VBA Archives - Excel Campus

Archive

Category Archives for "VBA"
8

2 Ways to Remove Duplicates to Create a List of Unique Values in Excel

Bottom line: In this article and video I explain 2 ways to remove duplicates to create a list of unique values. We look at the Remove Duplicates feature and a macro that makes the process much faster.

Skill level: Intermediate

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

2

New VB Editor for Excel 2016 for Mac

Bottom line: A new updated VB Editor has just been released for Excel 2016 for Mac to make it easier to write VBA Macros.

Skill level: Beginner

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

31

3 Ways to Delete Entire Blank Rows + Video Tutorial

Bottom line: Learn a few ways to delete entire blank rows from a data set or table in this article and video.

Skill level: Beginner

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

12

2 Keyboard Shortcuts to Select a Column with Blank Cells

Bottom line: Learn a few keyboard shortcuts to select all the cells in a column of the used range.  This is a solution for when the Ctrl+Shift+Down Arrow or Ctrl+Shift+End shortcuts don’t work.

Skill level: Intermediate

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

Free Webinar: 7 Steps to Getting Started with Macros & VBA

x

Grab My Free Cheat Sheet!

VLOOKUP Essentials Guide​

Vlookup Essentials Guide 317x407
Plus: Free Video Training Series on the Lookup Formulas!
x