there are times when i've inserted a column in middle of worksheet and
formulas magically appeared in that column (duplicated formulas which existed
on either side of inserted column). did i imagine this, and is this a
workbook option i can control?

I've seen this happen with rows--not columns.



mwam423 wrote:

there are times when i've inserted a column in middle of worksheet and
formulas magically appeared in that column (duplicated formulas which existed
on either side of inserted column). did i imagine this, and is this a
workbook option i can control?

--

Dave Peterson

hi dave, long time no talk to =D thanks for reply. fyi, a solution you
provided to a sort problem posted last week was very helpful to me the other
day, you da man!

"Dave Peterson" wrote:

I've seen this happen with rows--not columns.



mwam423 wrote:

there are times when i've inserted a column in middle of worksheet and
formulas magically appeared in that column (duplicated formulas which existed
on either side of inserted column). did i imagine this, and is this a
workbook option i can control?

--

Dave Peterson

Lurking is a good way to find lots of tips. I use it all the time!

mwam423 wrote:

hi dave, long time no talk to =D thanks for reply. fyi, a solution you
provided to a sort problem posted last week was very helpful to me the other
day, you da man!

"Dave Peterson" wrote:

I've seen this happen with rows--not columns.



mwam423 wrote:

there are times when i've inserted a column in middle of worksheet and
formulas magically appeared in that column (duplicated formulas which existed
on either side of inserted column). did i imagine this, and is this a
workbook option i can control?

--

Dave Peterson


--

Dave Peterson