Hey there!
I've got a strange problem.
I tried to have a picture change depending on what the value is in a dropdown list.
I got that to work no problem.
However, I now tried to write a makro which basically just adds another row of that feature to the sheet.
My strange problem now is, that inside the NameManager where I have to put the indirect() formula I get the correct code, but I manually have to delete any character and add it back in so that the reference works (refresh it in a kind).
Are there any suggestions on what I could have done wrong or how to automatically refresh that formula?
Thanks in advance!
Regards,
Bobbiii
(hopefully my english is good enough to explain my problem)
Bookmarks