Hmm....This is very odd. You're right. I'm actually getting the same results
as you. I can copy and paste manually and the button copies with the
selection. If I record the same steps as a macro and execute the macro, the
button is not included.

I'm not sure why the different behavior. I'll have to find some other
workaround.

Thanks so much for your time!
--
Jack
<<


"Dave Peterson" wrote:

Ps. I tried with both "move and size with cells" and "move but don't size with
cells".

Jack wrote:

I hope this is a quick. I'd like a named range selection to include ActiveX
controls within the range so I can copy the range elsewhere.

What I've found is if I reference the range as "B77:AM99" the ActiveX
controls are included in the selection. If, however, I create a named range
defined as "$B$77:$AM$99" then the ActiveX controls are not included in the
selection.

The Placement property of the controls is set to 2.

I'd prefer the named range approach if possible. Any suggestions?

Thanks!
--
Jack
<<

--

Dave Peterson