Use the change event and test for the condition.

http://www.cpearson.com/excel/events.htm
at Chip Pearson's site if you are not familiar with events.

--
Regards,
Tom Ogilvy

"Johnny Base" wrote in message
...
Is there a code.. such that

If a cell is a linked cell and in row 14 and greater, then Run code?

Example:
It would check if there is a linked cell in row 14... and find it, and
then run a code.
then it checks row 15 and finds linked items in row 15.. the code would
run
then it would check row 16... which has a linked cell, and the code would
run
and it should stop once there is no linked cell (or by another method)