ketenshi
02-17-2011, 08:09 PM
Hi All,
Here's the problem I've been having for a long time:
Lets say I have sheets: a and b
If I have selected cell a!A1 and typed "=" then clicked on sheet b and select cell A2 there, the formula for cell a!A1 should say "=b!A2" right? However, this is not always the case! Sometimes cell a!A1 will be blank and cell b!A1 will say "=b!A2" instead!
Initially I thought that this was because I was running some macros during SheetActivate but after a little bit of research, I've found that macros don't run when in edit mode.
Has anyone else experienced this problem before?
Thanks
Here's the problem I've been having for a long time:
Lets say I have sheets: a and b
If I have selected cell a!A1 and typed "=" then clicked on sheet b and select cell A2 there, the formula for cell a!A1 should say "=b!A2" right? However, this is not always the case! Sometimes cell a!A1 will be blank and cell b!A1 will say "=b!A2" instead!
Initially I thought that this was because I was running some macros during SheetActivate but after a little bit of research, I've found that macros don't run when in edit mode.
Has anyone else experienced this problem before?
Thanks