Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to add a text box to all my charts. I want to move the text box
to the lower right corner. My macro keeps returning this error at the point in the macro where the text box gets moved and re-shaped. Any help would be greatly appreciated. Option Explicit Sub Copyright() Dim chtobj As ChartObject For Each chtobj In ActiveSheet.ChartObjects With chtobj.Chart.TextBoxes.Add(131, 80, 86, 17) .Select .AutoSize = True .Formula = "='12 Charts'!$O$2" End With Selection.ShapeRange.IncrementLeft 45.74 Selection.ShapeRange.IncrementTop 64.49 Selection.ShapeRange.ScaleHeight 0.73, msoFalse, msoScaleFromBottomRight Next chtobj End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Object doesn't support this property or method" in Excel 2003 | Excel Discussion (Misc queries) | |||
runtime error 434, object does not support this method or property | Excel Discussion (Misc queries) | |||
VBA error: "object doesn't support this property or method" | Excel Discussion (Misc queries) | |||
object reference does not support this property or method | Excel Discussion (Misc queries) | |||
Object doesn't support this property or method (Error 438) | Excel Discussion (Misc queries) |