Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell address to Points
Is there a way to convert a active cells address to points for a location to
draw a autoshape? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Format numbers from percentage points to basis points | Excel Discussion (Misc queries) | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
text in Bullets/points in cell | New Users to Excel | |||
bullet points in one cell? | Excel Discussion (Misc queries) | |||
how do I separate different points within a cell in Excel | Excel Discussion (Misc queries) |