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

What is Big Data and Why Do Organizations Need It?

Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. But it’s not the amount of data that’s...

ITech Analytic Solutions

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 a VBA Module?

VBA code is stored and typed in the VBA Editor in what are called modules As stated on the VBA Editor page, a collection of modules is what is called a VBA project Every major Microsoft Office product...

ITech Analytic Solutions

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

VBA Function -

Using FORMAT Function in VBA we can modify the format of Numbers, Dates, Times & String. Syntax: FORMAT(expression, format, , ) 1. Formatting "Numbers" using FORMAT function in VBA SUB Format_Numbers() MsgBox...

Naga Satyanarayana Anantapalli

0 0

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.