Stacking columns across multiple sheets

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