I have a workbook, that several people are entering data in on a daily basis. They enter data on a worksheet, hit a macro enabled button and it saves the data on a separate hidden worksheet. I have another worksheet that totals scores, but when the data stored in the data sheet, the named range changes as rows are inserted. I have a line in my macro that changes the reference back every time the macro runs. It worked great until this year. I saved the file as a new name....deleted old data, everything works fine except it doesn't change my references back anymore. If I had created this workbook, I would have done things a bit different.....but anyway.......
There are no external connections, the named range is in the current workbook, when the code runs it does not stop, but it does not change the reference. Any thoughts?
Bookmarks