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

Not much help, but.....a general comment:

One of the best ways to learn to use Excel properly/efficiently/productively
is to build a large project. The reason: Large projects are particularly
unforgiving. Any mistakes in structure or programming results in enough
"retro-fit pain" to ensure that bad habits are quickly unlearned. You will
never again start even a "quick and dirty" analysis without laying the
groundwork in case that analysis suddenly and unexpectedly becomes a
production model.

I think we've all been there at least once.

***********
Regards,
Ron


"Bill Martin" wrote:

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

What Ron didn't say in his response is - no, you can't do what you want. You
can fiddle with a linked picture, but it will overlay whatever is on the left
side of your spreadsheet.

Sorry to be the bearer of bad news.

"Bill Martin" wrote:

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

Duke Carey wrote:
What Ron didn't say in his response is - no, you can't do what you want. You
can fiddle with a linked picture, but it will overlay whatever is on the left
side of your spreadsheet.

Sorry to be the bearer of bad news.

-------------

Ah well... It's the answer I expected/feared, but I'm willing to admit I don't
know *everything* about Excel <g and hoped there was a better answer.

Thanks...

Bill