Confirm Data from Other Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.
 
Back
Top