Kaval,

No shortcuts, just lots of code...
http://makeashorterlink.com/?K1AE311DA

Jim Cone
San Francisco, USA


"Kaval" wrote in message
...
I would like to determine for particular cells whether
1) they contain a formula
2) they have precedents
3) they have precedents on another sheet
4) they have precedents in another workbook
I can see what seems a longhanded way to determine the above (using
directprecedents method) but I wondered if there were any cute shortcuts?
For example, range("A1").directprecedents.count gives an error if there are
no precedents so I would need an error handling step.
Thanks, Kaval