Example:
Col A: 1,2,3
Col B: A,B,C
Col C: 9,8,7
Col D: X, Y, Z
Results
Col E: 1,2,3,A,B,C,9,8,7,X,Y,Z
Im completely new to VBA, as i've just converted my sheet from google sheets. I used to just be able to do ={A1:A3;B1:B3;C1:C3;D1:D3}, but there is no functionality like this in excel 2013 AFAIK.
The function would also have to handle a variable amount of parameters.
How do I get started!
Bookmarks