View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Jack is offline
external usenet poster
 
Posts: 10
Default Including ActiveX Controls in Names Range Selection

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
<<