Hello all,
I have a workbook with a lot of named ranges of varying sizes, anywhere from single celled to 20x50 cells. I am needing a code to export the named range values to a file that can later be imported to determine the values of the named ranges. I have found some code through prior questions, but the code breaks down with multi-cell named ranges.
My end goal is to simply export the named range values to a file, and then be able to re-import them into the program and have all the values in the program updated.
I have attached a simplified version of my program. My current file has my current "Save" button vba code. It does not have any "Import" button code. I have yet to come up with anything remotely successful.
Any help would be greatly appreciated.
Bookmarks