ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XL 2010: Parent of a Range can be a Shape? (https://www.excelbanter.com/excel-programming/442987-xl-2010-parent-range-can-shape.html)

Sebastien

XL 2010: Parent of a Range can be a Shape?
 
Hi
Anybody else noticed that:
- in xl 2010
- if you have add a shape to a sheet
- then ask: ? typename(activesheet.Shapes(1).TopLeftCell.Parent)
you get the answer: Shape
while in other versions of excel, you get: Worksheet
(the later makes more sense to me, at least).

Is that a bug or a 'weird' change in the object model?

Thanks,
Sebastien


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com