Compiling Data From Multiple Worksheets

[Jhmman]

Hi,

This is my first time using VBA, coming from matlab and C++.

I'm trying to combine a data from a number of 2-column (columns 1 and 3) worksheets so it will in the end resemble this pattern, where the number represents the source worksheet's index:

22
22
3-3
3-3
4--4
4--4
...

Then, the worksheet names will be used to create a header row. My code gives me 'Error 1004,' but I have no idea why:

Please Login or Register  to view this content.

Thanks!
Josh

[Jhmman]

More specifically:

Run-time error '1004': Application-defined or object-defined error

[ihmha]

Just ran this and it runs without error

Please Login or Register  to view this content.

[Jhmman]

This is awesome, thank you so much!