I have some speadsheets that are pretty big. Lots of sheets, lots of VBA macros
that manipulate the data, etc.

The thing is that after using the spreadsheet for several months, and gradually
adding more VBA subroutines to get it to do more and more, I'm now somewhat
smarter about how I should have structured the individual sheets to start with.
Too late smart... I would like to add a new column at the left edge say. All
the reprogramming and debugging that would require is just too ugly to
contemplate however.

So my question is whether it is somehow possible to add a new column at the
right end (col AX), but have Excel display that column at the left edge of the
sheet -- plainly labeled as AX, but just with the sheet somehow reformatted to
change the sequence of columns displayed on screen?

Thanks...

Bill