Just a complete wild guess...

Close excel and clean up your windows temp folder. Lots of programs store junk
there (like excel) and if it gets large, it can confuse excel.

Close excel
Windows start button|Run
type:
%temp%
and clean up everything you can

Then back to excel to test.

Jack wrote:

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


--

Dave Peterson