Updating cells referenced to worksheets in same workbook

  • Thread starter Thread starter D Williams
  • Start date Start date
D

D Williams

Hello
I'm having trouble with formulae in a sheet ('SheetA') which references a
cell in a worksheet ('SheetB') in the same workbook Sheet B is made after
Sheet A by a macro.

Formulae in Sheet A don't seem to recognise when Sheet B is made, the cells
still return 'ref#!'. The cell do return the correct number when the
formulae are written in again (exactly the same as previously).

Is there a way to update Sheet A automatically?
 
Hi
I would include the formula creation within your macro. Excel does not
convert former #REF errors back to normal functions in this case
 
Back
Top