mdavide
Board Regular
- Joined
- Oct 19, 2004
- Messages
- 211
Hi all,
I've a strange problem when I try to change width/height of a graph via VBA: chart changes but with wrong values, that is I write width=77 but it sets width=21! why?
if I run step by step in debug mode, the code works fine!?!
this is my part of code
where ch is a Chart
thanks
DM
I've a strange problem when I try to change width/height of a graph via VBA: chart changes but with wrong values, that is I write width=77 but it sets width=21! why?
if I run step by step in debug mode, the code works fine!?!
this is my part of code
Code:
ch.Parent.Parent.Shapes(ch.Parent.Name).Top = 0
ch.Parent.Parent.Shapes(ch.Parent.Name).Left = 0
ch.Parent.Parent.Shapes(ch.Parent.Name).Width = 100
ch.Parent.Parent.Shapes(ch.Parent.Name).Height = 150
ch.PlotArea.Top = 0
ch.PlotArea.Left = 3
ch.PlotArea.Width = 77
ch.PlotArea.Height = 130
where ch is a Chart
thanks
DM