Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Here is a good one I have been pondering for a while, still, in all my efforts, I have not gotten what I really need. I am not an Excel-VBA expert, so I am hoping somebody in here can give some insite. OK, unforunately, there is no row insert/delete event..WISH LIST I have 2 seperate named ranges; if I change one, I would like the other to change and look exactly the same as the one that I just changed. That means, if I delete a row in one, then I want the other to delete a row and update all the values in the cells to match precisely. Same if I add a row. I hope this makes sense and is this possible? If may work on a Change event but it is not necessary really; if I change one, then I don't mind clicking a macro to update. Thanks in advance! ML |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... | Excel Programming | |||
building formulas that change frequently using named cell ranges | Excel Worksheet Functions | |||
Change Named Cell ranges based upon value of another cell? | Excel Programming | |||
Named ranges vs setting range in code | Excel Programming | |||
Through code : Making a global change to 100 templates | Excel Programming |