I know Excel macros can do very cool things, however can it do the following.
I have about 12 worksheets (all in the same wookbook) that are getting data
from 12 difference worksheets (all in the same workbook). Everything is in
the same workbook. Is there a way to confirm that the formulas that are
getting the data from are pulling from the right cells?

Thanks
Frank

How would any code determine whether the reference in a cell is to the
"right" cell? For example, if Sheet1!A1 has the formula =Sheet2!C10, how
would code know that C10 is the "right" or "wrong" reference?




--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"Beep Beep" wrote in message
...
I know Excel macros can do very cool things, however can it do the
following.
I have about 12 worksheets (all in the same wookbook) that are getting
data
from 12 difference worksheets (all in the same workbook). Everything is
in
the same workbook. Is there a way to confirm that the formulas that are
getting the data from are pulling from the right cells?

Thanks
Frank

Determining whether formulas refer to the correct cells should be done
when constructing the workbook. Locking formula cells when all is
completed would obviate the need for any kind of "confirmation" code
which, as Chip implies, is impossible to code.

On Jun 19, 2:57 pm, Beep Beep
wrote:
I know Excel macros can do very cool things, however can it do the following.
I have about 12 worksheets (all in the same wookbook) that are getting data
from 12 difference worksheets (all in the same workbook). Everything is in
the same workbook. Is there a way to confirm that the formulas that are
getting the data from are pulling from the right cells?

Thanks
Frank