tommy1234
03-27-2011, 10:42 AM
Hello
i need to update text inside a shape.
the value for the text is taken from a pivot table
i want to update the text inside the shape each time the pivot is change.
ActiveSheet.Shapes("Lines").Select
Selection.Characters.Text = Worksheets("Pivot").Range("d79").Value
thanks
i need to update text inside a shape.
the value for the text is taken from a pivot table
i want to update the text inside the shape each time the pivot is change.
ActiveSheet.Shapes("Lines").Select
Selection.Characters.Text = Worksheets("Pivot").Range("d79").Value
thanks