software

I have a large workbook with lots of macros that has worked well for a
couple years. Suddenly, any text or number I type or copy into any cell
within a certain column repeats itself to as many repetitions as is
viewable, depending on the column width. So if the column is wide enough to
show three characters and I type CAT, but then drag the column wider, I
would get CATCAT, then CATCATCAT, etc. The cell edit box only shows CAT, and
math still works OK, so it may be more of a view or display problem than a
cell contents problem. I read about using an asterisk as a repetition
initiator when using a custom cell format, but these cells just have a
general format. Maybe there is some setting I have accidentally initiated,
or maybe my macros are rebelling.

Sorry if I'm the 99th person to ask about this, but it has me stumped.
Thanks.
Carl
Hi!

Select any cell that this happens to. Check this setting:

Formatgt;Cellsgt;Alignment tab
In the first section under Text Alignment: Horizontal, does that drop down
have Fill selected? If so, that's you're problem.

Biff

quot;xlcjquot; gt; wrote in message
...
gt;I have a large workbook with lots of macros that has worked well for a
gt;couple years. Suddenly, any text or number I type or copy into any cell
gt;within a certain column repeats itself to as many repetitions as is
gt;viewable, depending on the column width. So if the column is wide enough to
gt;show three characters and I type CAT, but then drag the column wider, I
gt;would get CATCAT, then CATCATCAT, etc. The cell edit box only shows CAT,
gt;and math still works OK, so it may be more of a view or display problem
gt;than a cell contents problem. I read about using an asterisk as a
gt;repetition initiator when using a custom cell format, but these cells just
gt;have a general format. Maybe there is some setting I have accidentally
gt;initiated, or maybe my macros are rebelling.
gt;
gt; Sorry if I'm the 99th person to ask about this, but it has me stumped.
gt; Thanks.
gt; Carl
gt;
Sure enough, Biff, that was the problem. Thanks for the help.

So assuming I did not accidentally make just the correct six-mouse-click
mistake to re-format those cells, is it likely that during the course of
hundreds of opening and re-saves Excel could lose track of a setting. If
so, is there some procedure to verify that nothing except data values have
changed during a session?

Carlquot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; Select any cell that this happens to. Check this setting:
gt;
gt; Formatgt;Cellsgt;Alignment tab
gt; In the first section under Text Alignment: Horizontal, does that drop down
gt; have Fill selected? If so, that's you're problem.
gt;
gt; Biff
gt;
gt; quot;xlcjquot; gt; wrote in message
gt; ...
gt;gt;I have a large workbook with lots of macros that has worked well for a
gt;gt;couple years. Suddenly, any text or number I type or copy into any cell
gt;gt;within a certain column repeats itself to as many repetitions as is
gt;gt;viewable, depending on the column width. So if the column is wide enough
gt;gt;to show three characters and I type CAT, but then drag the column wider, I
gt;gt;would get CATCAT, then CATCATCAT, etc. The cell edit box only shows CAT,
gt;gt;and math still works OK, so it may be more of a view or display problem
gt;gt;than a cell contents problem. I read about using an asterisk as a
gt;gt;repetition initiator when using a custom cell format, but these cells just
gt;gt;have a general format. Maybe there is some setting I have accidentally
gt;gt;initiated, or maybe my macros are rebelling.
gt;gt;
gt;gt; Sorry if I'm the 99th person to ask about this, but it has me stumped.
gt;gt; Thanks.
gt;gt; Carl
gt;is there some procedure to verify that nothing except data values have
gt;changed during a session?

Not that I'm aware of. That setting is fairly well hidden and it's hard to
imagine someone accidentally changing it. Anyone else have access to the
file?

Biff

quot;xlcjquot; gt; wrote in message
. ..
gt; Sure enough, Biff, that was the problem. Thanks for the help.
gt;
gt; So assuming I did not accidentally make just the correct six-mouse-click
gt; mistake to re-format those cells, is it likely that during the course of
gt; hundreds of opening and re-saves Excel could lose track of a setting. If
gt; so, is there some procedure to verify that nothing except data values have
gt; changed during a session?
gt;
gt; Carl
gt;
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Hi!
gt;gt;
gt;gt; Select any cell that this happens to. Check this setting:
gt;gt;
gt;gt; Formatgt;Cellsgt;Alignment tab
gt;gt; In the first section under Text Alignment: Horizontal, does that drop
gt;gt; down have Fill selected? If so, that's you're problem.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;xlcjquot; gt; wrote in message
gt;gt; ...
gt;gt;gt;I have a large workbook with lots of macros that has worked well for a
gt;gt;gt;couple years. Suddenly, any text or number I type or copy into any cell
gt;gt;gt;within a certain column repeats itself to as many repetitions as is
gt;gt;gt;viewable, depending on the column width. So if the column is wide enough
gt;gt;gt;to show three characters and I type CAT, but then drag the column wider,
gt;gt;gt;I would get CATCAT, then CATCATCAT, etc. The cell edit box only shows
gt;gt;gt;CAT, and math still works OK, so it may be more of a view or display
gt;gt;gt;problem than a cell contents problem. I read about using an asterisk as a
gt;gt;gt;repetition initiator when using a custom cell format, but these cells
gt;gt;gt;just have a general format. Maybe there is some setting I have
gt;gt;gt;accidentally initiated, or maybe my macros are rebelling.
gt;gt;gt;
gt;gt;gt; Sorry if I'm the 99th person to ask about this, but it has me stumped.
gt;gt;gt; Thanks.
gt;gt;gt; Carl
gt;
gt;