code needed to update links
After adding some lines of code to Add/Remove Subs myself that did the job,
opted for formula solution instead: =OFFSET(ClassHours!$AD$3,ROW()-2,0) Copied down target column to fill needed range. -- David David wrote XL2000 Hopefully I can explain this adequately to get a solution. I have a workbook in which I am frequently adding and deleting students via code. I need that same list of students on another sheet, so I have selected the range of students (and beyond to allow for expansion), Copy (ed) and on the other sheet issued Edit|Paste Special|Paste Link. So far, so good--until I run my code to add or delete a student. When I look at the sheet with the links after, say, deleting a student, I see #REF in the cell that once held the deleted student's name. I can go to the top of the list and use the grab handle to drag down the entire range to repopulate the cells and everything is fine, but I don't want to have to do this every time. What can I do? |
All times are GMT +1. The time now is 01:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com