Select Range Question

[Calvin De Beverly]

I am sure I doing something simple to make this error out but I just can't see it. I followed examples but no joy? See the comment in the code for the question; thanks.

Please Login or Register  to view this content.

[mc84excel]

Try this.

Please Login or Register  to view this content.

[Calvin De Beverly]

Thank you so very much that did it and I understand what I did wrong now.

[jolivanes]

Instead of

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

Too late I guess.
From what I see is that one names a range and mine creates a named range.