Range Address Is Correct Columns Count Is Not Correct

Hi all,

Using Excel 2010,

My snippet below is returning the correct range address $D:$M, but the wrong Columns.Count : 9 (Should be 10)
Any ideas why that may be?

thanks
W

Please Login or Register  to view this content.

Full:

Please Login or Register  to view this content.

I'm not going to wade through all of that, but you set a reference to r3, and then resize r3. The reference, however, remains to the original range. For example,

Please Login or Register  to view this content.

Thanks shg,

You nailed it. I was not aware of that. I thought the resize would change the original "With r"

Thanks
w