Quote Originally Posted by fixer
with one macro both the problem has been solved
So what you are possibly trying to say is something similar to , you don’t need the macro anymore, as the one you pasted ( https://excelfox.com/forum/showthrea...ll=1#post14691 which comes from another Thread, https://excelfox.com/forum/showthrea...ll=1#post14676
https://excelfox.com/forum/showthrea...ge29#post14663
) makes that macro no longer needed.

Your bad explanations, or lack of an explanations, as in this case, makes things very confusing for others reading this post…
You still need to try to improve on you replies and explanations.