.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" <AA2e72E@discussions.microsoft.com> wrote in message
news:E7373309-0E4D-44EC-9B24-A5FBD17951D3@microsoft.com...
> 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?