Formula linked to cell with Macro

B

Beginner

Hi

Everytime I run a macro in one worksheet (A), another worksheet (B) which
has a formula linking back to a value in (A) which the macro produces,
returns a #REF!.

Can you not have a formula linking to a sheet which you run a macro on?

Any help would be appreciated - thanks
 
Top