VSTACK function in a macro to stack multiple table columns in a different table

[sspatriots]

I've trying to find anything I can on the use of the VSTACK function in a macro and come up empty. Just wondering if anyone here can point me in the right direction to be able stack multiple columns from a table into another table, but in one single column. Any help would be greatly appreciated. Thanks, SS

 

[StephenCrump]

You could do this in other ways in VBA, without using VSTACK.

But if you specifically wanted to use VSTACK, a simplistic example:

Range("D2:D9").Value = Evaluate("VSTACK(A2:A4,B2:B6)")

'or

With Range("D2:D9")
    .Cells(1).Formula2 = "=VSTACK(A2:A4,B2:B6)"
    .Value = .Value 'optional
End With

	A	B	C	D
1	Input			Output
2	a	p		a
3	b	q		b
4	c	r		c
5		s		p
6		t		q
7				r
8				s
9				t
Sheet1

These hard-coded cell references can be made dynamic of course.

 

[sspatriots]

I like the second part of your response. I'll give that a try today. Thank you... I'll come back and let you know how it went.