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