Skip to content
Excel Unlocked

Let's Unlock the Power of Excel for You

  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us
Excel Unlocked
  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us
Insert rows using vba in excel infographics

Insert Rows using VBA, Copy Formatting

Today, we are going to learn an important concept of adding rows to the worksheet using VBA. We will learn to insert a single row… Read Article
infographics do until loop in vba in excel

Do Until Loop in VBA – Usage with Examples

In the previous article, we learned about the usage of Do While Loop. The Do Until loop in VBA also works on the basis of… Read Article
infographics change column width and row height using vba

Change Row Height, Column Width VBA (Autofit)

Today we will learn to change the row height and column width using VBA in excel. We will also learn to automatically autofit the rows… Read Article
used range property in vba infographics

UsedRange Property in VBA – Examples

In the previous article, we learned to select a range using VBA. Today we will learn about the UsedRange property in VBA. So let us… Read Article
apply cell border using VBA infographics

Apply Border to Cells using VBA in Excel

Today, we will learn to apply borders to cells using VBA in excel. We will learn with the help of examples to apply different border… Read Article
infographics active cell in vba

How to Use Active Cell in VBA

In one of the previous articles, we learned about cells and ranges. Today, we will learn to use Active Cell in VBA. We will learn… Read Article
class modules in vba infographics

VBA Class Modules – Create Objects

VBA is an Object Oriented language. It contains the use of various Objects, their functions, and properties like Worksheets. Today, we will learn to create… Read Article
infographics Do While Loop in VBA

Do While Loop in VBA – Usage with Examples

We know about a number of loops like For Next Loop and For Each Loop. Today we will learn about another important type of loop… Read Article
infographics array of user defined type in vba

Array of User Defined Type in VBA

In the previous article, we learned how to use the User Defined Types. User Defined Type refers to a named grouping of built-in data types.… Read Article

User Defined Data Type – Type VBA

We learned about pre-defined data types in VBA in one of our previous articles. Today we will learn about User Defined Data Type in VBA… Read Article
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
Older posts
Newer posts
← Previous Page1 Page2 Page3 Page4 … Page42 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Comments

  • Nilesh Patel on Excel DATEDIF Function – Find Difference Between Dates
  • daniel on Excel XNPV Function – NPV With Irregular Cash Flows
  • wout on How to Insert Picture or Image in Excel Comment

Archives

Categories

  • Charts (69)
  • Functions (281)
  • Tips and Tricks (73)
  • VBA and Macro (73)
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ExcelUnlocked.com 2025