Cell address to Points
 

Is there a way to convert a active cells address to points for a location to
draw a autoshape?

Cell address to Points
 

CS,

You can use a combination of the range object Top, Left, Width, and Height
properties to get the location of any of a cell's corners. For cell C3, for
example:

Top is Range("C3").Top
Bottom is Range("C3").Top + Range("C3").Height
Left is Range("C3").Left
Right is Range("C3").Top + Range("C3").Width

so you can get any combination of Top Bottom, Right and Left.

HTH,
Bernie
MS Excel MVP

"CStephenson" wrote in message
...
Is there a way to convert a active cells address to points for a location
to
draw a autoshape?