Hi, i'm trying to copy images based on an adjecent cell value using name manager but it does something strange to the image... On the attached example I want cell E5 to be the flag of the country in F5 by using an index/match formula in name manager but the flag seems to shrink and break up when the country changes and the original flag is changed. Any ideas why? :-)
What you get is a "photography" of the cell that the flag is in. Try and move the flags around and you'll see that you can get all kinds of weird images, half a flag etc.
The solution would be to make a macro that perfectly aligned your flags with the cells, I think.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Thats sorted it perfectly, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks