Stacking columns across multiple sheets

This little macro will do it:

Please Login or Register  to view this content.

Thanks!

This seems to bomb however when I hit sheet 3. I took out sheet 3 and it does exactly what I want with sheet 1 and 2. When I leave 3 in it gives me either a '400' if I run it from the macro window...or a 'Run-time error '1004': Application-defined or object-defined error' if I run it from the vb window.

Any ideas? The 3 worksheet example above is actually just an example...there are quite a number of tabs more that I really need to compile. Will this scale up to as many tabs as I need?

Michael Stinson

If you want me to troubleshoot your sheet, you'll have to post it. No idea why it won't work as designed since it does on mine...maybe a sheet naming error?

Also, yes, it will scale up as high as needed. Make sure you're using the last version I posted, the earliest version had a few lines of unneeded code.