ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   linked cells loop? (https://www.excelbanter.com/excel-programming/293969-re-linked-cells-loop.html)

Tom Ogilvy

linked cells loop?
 
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)





All times are GMT +1. The time now is 03:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com