Hi friends,
I hava a strange problem with advanced filtering. I am developing some excel vba macro projects in my job. I have developed an excel sheet that contains some shapes(oval). These shapes are grouped in some manner and i need to paint these shapes with different colors. These colors are contained in cells each one to one cell. So I will read the color from the cell and change the shape color with this color. There is no problem until this. I did this, and no problem with that. But yesterday added new functionality to the application which makes advanced filtering on the shapes. And when i run the advanced filtering then remaining shapes shown normally with their group color except the first one. I think it is a bug but may be a reason that i don t know about. If you have any idea with these could you share it with me pleas as soon as possible?
Thank you for your responses,