I want to write a function that will check to see if a cell has har
coded data in it. For example in the formula below, you would want t
check and see that all the operators (=,+,-,*,/) are followed by eithe
a $ or a letter. So below the 2 would be picked up because it follows
sign.
=$C$10/E10+G10+2/C10*E10
I want to do this so that I can run a check on a spreadsheet to mak
sure their are no hidden easter eggs in it.
Thanks
--
ExcelMonke
-----------------------------------------------------------------------
ExcelMonkey's Profile:
http://www.excelforum.com/member.php...nfo&userid=522
View this thread:
http://www.excelforum.com/showthread.php?threadid=26906