VBA Array Function: The Array function in VBA generates an array containing the given set of values.

Syntax

Parameter

Arglist (required) – This parameter the list of values that you want to make up the array wherein the values are separated by commas.

Return

This function returns an array containing the given set of values.

Example 1

Output

Name
Alan
Christopher
Elmer
Frank
VBA Array Function

Example 2

Output

Names Identity Number
Reema 15023027
Varun 16023014
Amar 15023090
Shukla 15023012
Pradeep 16023021
Govind 16023087
Shradha 16023114
Sourav 16023123
Kumar 15023019
Twinkle 15023456
VBA Array Function

Example 3

Output        

VBA Array Function
VBA Array Function
VBA Array Function
VBA Array Function
VBA Array Function
VBA Array Function
Name Sales Amount
Reema 4567
Pradeep 9876
Rahul 12345
Rita 6789
Sunita 9876
Sheena 4356

Pin It on Pinterest

Share This