.AddShape(Type, Left, Top, Width, Height)

The Left, Top, Width & Height arguments are measurd in points. In Excel, a
shape can resize with the cell it is in.

How can I establish the the size/location of a cell in points so that I can
add a shape of percisely the same dimensions?

Cells have the same properties!

"AA2e72E" wrote:

> The Left, Top, Width & Height arguments are measurd in points. In Excel, a
> shape can resize with the cell it is in.
>
> How can I establish the the size/location of a cell in points so that I can
> add a shape of percisely the same dimensions?

set r = Range("B9")

..AddShape(type,r.Left, r.Top, r.Width, r.Height)

--
Regards,
Tm Ogilvy


"AA2e72E" <[email protected]> wrote in message
news:[email protected]...
> The Left, Top, Width & Height arguments are measurd in points. In Excel, a
> shape can resize with the cell it is in.
>
> How can I establish the the size/location of a cell in points so that I
can
> add a shape of percisely the same dimensions?