I use "union" to combine two ranges
Is a way to remove one range from another range?Please Login or Register to view this content.
I use "union" to combine two ranges
Is a way to remove one range from another range?Please Login or Register to view this content.
Not understanding your issue. Can you post an example of what you have and what you want? Perhaps a real life example will be clearer.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
oRng.Address = "$A$1:$A$2"Please Login or Register to view this content.
I want to remove one range from another so something like the union function but opposite. I don't want to add one range to another I want to remove one range from the other
nRng.Address = "$A$2"Please Login or Register to view this content.
If the 2 ranges are not contiguous then you can user the Range "Areas" property to do this:-
Regards MickPlease Login or Register to view this content.
Perhaps this article on a user function Subtract may help.
http://dailydoseofexcel.com/archives...-and-subtract/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks