Stack Combine Multiple Columns Excel VBA Macro

n this video we see how to stack or combine multiple columns into a single column in Excel using VBA macros. Depending on the scenario, that’s something you can probably do without macros, but in some cases, and especially when dealing with a lot of data, is more convenient, faster, and more secure to do it with macros. This is a simple macro to stack the selected columns into one column either in the same or a different worksheet. The macro can easily be adapted to stack the columns skipping the headers by changing just one line of code.

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:

[hiragangsta]

This helped me a lot! Thank you. Also, can we somehow make this macros to act automatically when I add some new data to the chosen columns? I have three columns (C:E) to which I often add new information, and I want this macros constantly stack all these values to a single column.

[ryanoheron]

Thank you for this! I wanted to add some code that would separate each column (meaning a blank line between each column once stacked)
Is this possible?

[Swathikumar-sjor]

I am getting error msg as "Object does not support this property or method". Can u pls help me out.