How to concatenate multi arrays into 1 array in Exel VBA

Question

I have several worksheets in an Excel and each of the worksheets contain 1 Form. I have grouped similar forms into an array in order to apply a function across all relevant worksheets.

FORM_01 = Array(FORM001.Name,FORM_001_001.Name)
FORM_02 = Array(FORM002.Name, FORM_002_001.Name)

Can I concatenate FORM_01 and FORM_02 into a new consolidated array like this?

FORM_combine =Array(FORM001.Name,FORM_001_001.Name,FORM002.Name, FORM_002_001.Name)

Thanks.

Possible duplicate of How do I Merge two Arrays in VBA?

Pᴇʜ
– Pᴇʜ

2017-09-18 07:03:49 +00:00
Commented Sep 18, 2017 at 7:03 — Pᴇʜ
– Pᴇʜ, Commented Sep 18, 2017 at 7:03

Mrig · Accepted Answer · 2017-09-18 07:16:01Z

0

Something like this

FORM_01 = Array("a", "b")
FORM_02 = Array("c", dD")
FORM_combine = Split(Join(FORM_01, Chr(1)) & Chr(1) & Join(FORM_02, Chr(1)), Chr(1))

This will give FORM_combine as ("a", "b", "c", "d")

Got this from here.

answered Sep 18, 2017 at 7:16

Mrig

11.7k2 gold badges15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to concatenate multi arrays into 1 array in Exel VBA

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related