I will repost this question as there are more than one intersected ranges.
Its very confusing.

"Janis" wrote:

I am trying to understand this range because the original spreadsheet changed
the column numbers and now the macro doesn't work.

Does this mean the intersection of column D and the Used Range which would
be in other words all of column D up through the last row in column D which
would seem to be the intersection to me?

thanks,