Get a range that is the difference between a range and UsedRange of a sheet

[capson]

I am trying to get a range that is the difference between a range and the UsedRange of a sheet

I get the error "Object variable or With block not set" and r.Select is highlighted?

I have set r = DiffRngAndUsedRange(rng) which is a range not sure what my problem is

Thanks

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[capson]

Hello Nori, I get the same error, I can not see how your code is different

[Norie]

In the original code you had this which, if the 2 ranges don't intersect, will exit the function without returning anything.

Please Login or Register  to view this content.

I changed the code so it will return a union of the 2 ranges if they don't intersect.

Please Login or Register  to view this content.

[capson]

Thanks, I appreciate it