VBA Static Array Vs Dynamic Array

Umasankar Natarajan

06/06/2017 0 0

There are two types of array in VBA, Static array and Dynamic array.

Static array:

Array is dimenstioned during design time.
Array size can not be changed.
By using erase function, only array element values in the memory will be emptied, elements memory will not be deleted.
Memory is fixed during design time.

Dynamic array:

Array is dimenstioned during runtime
Array size can be changed (Shrink or Enlarge) any number of times.
By using erase function, both array element values and elements memory will be deleted.
We can utilise the memory efficiently.

0 Like 0 Dislike

Follow 0

Other Lessons for You

Excel Tip: Use Index Or Match Instead Of Vlookup Or Hlookup.

Hi, In today's Excel topic we will see how Index & Match function is superior than Vlookup/Hlookup. With Index and Match, the return value need not be in the same column as the lookup column, unlike...

Karthik Dale

0 0

Tips of learning Java Language/Other Programming Languages

1.You should know the basic concept: If we talk about programming languages so basic concept are same in all the high level languages. So you should know the basic concept firstly then you can easily understand...

ICreative Solution

0 0

Excel Tip 1: VLOOKUP to pull left column values

Hi,Most of us know that using Vlookup function we can get the right column values, however by using Choose function in Vlookup table array, we can pull left column values as well. In the below screenshot...

Karthik Dale

0 0

Concatenate Function

Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...

Saburudeen MA

0 0

What is M.S.Project ?

MICROSOFT PROJECT contains project work and project groups, schedules and finances.Microsoft Project permits its users to line realistic goals for project groups and customers by making schedules, distributing...

Bright Computer Education

0 1

Looking for Excel Macro Training ?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for Excel Macro Training Classes?

The best tutors for Excel Macro Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Excel Macro Training with the Best Tutors

The best Tutors for Excel Macro Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.