Cell address to Points

  • Thread starter Thread starter CStephenson
  • Start date Start date
C

CStephenson

Is there a way to convert a active cells address to points for a location to
draw a autoshape?
 
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
 
Back
Top