Hi Catlin, I really appreciate your efforts and advice and will try to optimize the inherited files. Many Thanks!
Hi Catalin, Thanks for sharing your thoughts. As I mentioned, the code I provided is comparing two hard coded named ranges on the same sheet. Ca...
Many thanks Catalin for your very useful clarifications. As I am not experienced programmers I was just wondering, why the code I provided can do the ...
Hi Catalin, Before sending my previous message I tested the provided code and got the shown screenshot result. Please advise.
Hi Catalin, Thank you for your reply and efforts. What I intend to do is to highlight the data that exist in one sheet but not in the other, wit...
Hi Philip, Thanks for your reply. By "identical named ranges" I meant the names are the same, the ranges are different sizes and location o...
Hi, Catalin, Find attached a sample of typical files including Named Ranges.
Hi, Catalin Thanks for your interest. I just posted the following, hope it helps clarifying my request. The below code works very well for my data,...
Hello Experts, Need you assistance to use the below code (or similar approach) to perform the following tasks: 1- Ask to open two workbooks. 2- For ea...