Excel VBA Arrays & Functions Series 3

In session of this course you will learn:What are the arrays in VBA? Why we use them? Why they are so powerful and holds so much weightage in VBA learning. Deep level discussion on Arrays from very basic level to super advanced levels using examples
What is their by-default index system and how we can change it using option base? How to declare option base and if it can be used for all types of arrays or not
What are static and dynamic arrays? Which one we should choose or how we can change static to dynamic
How to use arrays with VBA loops and if functions. They work like magic together. You should have basic knowledge of Loops and IF functions including nested IFs
How to use dim or redim statements. Their real use in projects. How to use variable value in arrays and what is the purpose of using them in arrays
How to use split function, one of the best function we can use in arrays. How arrays work under split function
How option base 1 works for arrays created by split function
How to change or modify the size of Arrays - How many times array can be declared with in a sub routine and while modifying the arrays do we lose the existing values or can keep them while adding new values
What is the use of preserve word in arrays and how we can use it to hold the values? What happens if we do not use them. How and where we use them. A complete discussion on its use
For more understanding on arrays tutorial, we are discussing amazing Projects. Only for you. In-depth discussion
We have several important Questions discussed from the VBA interview perspective as well
For more confidence and to handle complex situations we have Assignments also. My online assistance will be given to you whenever you have any doubts or questions on this forumIn second session you will learn:
.
We are learning everything about VBA functions from their definitions to their practical use in excel day to day work life yourself. Which one is better?
My online support forever for you in case...