View Single Post
  #1   Report Post  
Harry
 
Posts: n/a
Default Formula abruptly changed

Hi,
Can anyone tell me why this happened?
All of my formula cell references moved up a number!
(e.g. 'Sheet3'!$F$3:$F$9999="yyyyy" changed to 'Sheet3'!
$F$4:$F$10000="yyyyy"
All formulas, array entered or not... everything!

What occured:
My workbook is 3 sheets long.
Sheet3 is data only. I updated this from top to bottom
from cut and paste procedure. Row 1 acts as a header, a
blank row2 exists by design then lots of data from row 3
down with lots of columns.
Sheet2 contains my calculations/formulas. Problem rests
here!
Anybody experience this before?

TIA