Skip to content
Excel Unlocked

Let's Unlock the Power of Excel for You

  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us
Excel Unlocked
  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us

VBA and Macro

infographics dynamic arrays in vba

Dynamic Arrays in VBA – ReDim and Preserve

In one of the earlier articles, we learned how to use one-dimensional and multidimensional arrays. Today we will learn about another important concept of using… Read Article
infographics multidimensional array in vba

Multidimensional Arrays in VBA – Excel

In the previous article, we learned about implementing 1 Dimensional Arrays. Today we will learn about the usage of Multidimensional Arrays in VBA with the… Read Article
for loop in vba infographics

For Loop in VBA – Excel

In the previous article, we learned about the For Each Loop. Today we will learn about another important loop used in VBA which is For… Read Article
infographics arrays in vba

Arrays in VBA – Excel

Today we will learn about arrays in VBA. We will learn about how to declare and initialize arrays of different data types to store values.… Read Article
for each loop in vba infographics

For Each Loop VBA – Excel

Today we will learn about an important type of loop which is For Each loop in VBA Excel. Loops are a special type of control… Read Article
infographics clear cell content using vba

Clear Cell Content and Formatting using VBA

In this article, we will learn how to clear a cell’s contents, the range of cells or, the named range. We would also learn to… Read Article
infographics check empty cells using vba

Empty Cells VBA – Check, Count, and Highlight

Today we would learn about how to check if a cell is empty using VBA in Excel. We would also learn to count the total… Read Article
infographics merge cells using vba in excel

Merge and Unmerge Cells using VBA in Excel

In this tutorial, we would learn about different ways to merge cells using VBA. We would also write a Sub Procedure that merges the cells… Read Article
worksheets in vba infographics

Working with Worksheets in VBA Excel

In one of our previous articles, we learned about Collections. Today we will learn about one of the most used and important collections that is… Read Article
ThisWorkbook in VBA infographics

ThisWorkbook in VBA – Examples

You must know about an Active Workbook in Excel. In this blog, we will learn about some properties and methods for ThisWorkbook in VBA and… Read Article
infographics sort range using vba

Sort Range using VBA – Table Header

We can sort a range of cells in excel using simple ways like the Sort option or SORT Function. VBA is required to sort a… Read Article
infographics worksheet events in vba

Worksheet Events in VBA Excel

Worksheet Events are important to learn. There are times when we want to run a macro/sub procedure when a cell changes its value when the… Read Article
Older posts
Newer posts
← Previous Page1 Page2 Page3 … Page5 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Comments

  • wout on How to Insert Picture or Image in Excel Comment
  • ALAMIN ABUBAKAR ZARMA on TRUE and FALSE Function in Excel
  • Matthias Lüpke on How to Send Email From Excel Automatically

Archives

Categories

  • Charts (69)
  • Functions (280)
  • Tips and Tricks (73)
  • VBA and Macro (52)

Mission

ExcelUnlocked is dedicated to unlocking the power of Excel for professionals, students and all others who use Excel in their day to day activity.

Excel Unlocked
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ExcelUnlocked.com 2023