L
laneman
I have two workbooks with simple identical formulas that update
control number after the macro runs. One workbook is ok. The other wil
not update the control number. Instead, it changes the cell referenc
to one row higher and returns the previous control number. Here's wha
each workbook looks like:
Sheet one: cell C7 is the control number:20040004.formula for C7 i
:=sheet2!'B5+1'
Macro: Insert new row 5 on sheet 2,cut data from sheet 1 row 7, past
into sheet 2 row 5.
After the macro runs, the cell ref. on sheet 1, C7 changes to =B6+1.
tried adding $ around $B5$+1, locking cells, etc. Still, one workboo
is fine, one is not
control number after the macro runs. One workbook is ok. The other wil
not update the control number. Instead, it changes the cell referenc
to one row higher and returns the previous control number. Here's wha
each workbook looks like:
Sheet one: cell C7 is the control number:20040004.formula for C7 i
:=sheet2!'B5+1'
Macro: Insert new row 5 on sheet 2,cut data from sheet 1 row 7, past
into sheet 2 row 5.
After the macro runs, the cell ref. on sheet 1, C7 changes to =B6+1.
tried adding $ around $B5$+1, locking cells, etc. Still, one workboo
is fine, one is not