I am looking to build a routine which check all the cells in my workboo
and finds the cells which have hard coded constants in them and print
their cell address in a defined sheet.

For example, the routine would run and lets say it finds cells wit
hard coded data ("=3", "=4*5, etc )or hard coded date within formula
(=A2+5). It would then print out the cell addresses on a define
sheet in a single column:

Sheet1!A2
Sheet2!G48
Sheet3!J56

Does anyone know how to do this?

Thanks in advanc

--
ExcelMonke
-----------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522
View this thread: http://www.excelforum.com/showthread.php?threadid=26181