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" <(E-Mail Removed)> wrote in message
news:E4DD6B67-663C-4FCE-AA9C-(E-Mail Removed)...
>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 <BeepB...@discussions.microsoft.com>
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