![]() |
forcing excel to update the Cell Link when copying Combo Boxes
I am using combo boxes to enter information. Directly under each combo box is
the "Cell Link" cell for that combo box. When I copy the row down, the combo box copies down with it's Cell Link cell, as expected. However, the new combo box is still linked to the origional cell, and must be altered manually to link to the new "Cell Link" cell. Is there any way to force excel to automatically update the address of the "Cell Link" to the new (destination) cell? |
All times are GMT +1. The time now is 10:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com