Hy everybody!
I have got a problem because of the Excel language pack perhaps... I've got a Diagram 1 (hungarian name of the chart) and the Excel macro refers to Chart 1 in the english version of the Excel. In the Hungarian version the macro in the macro record function enter the Diagram 1 name. How could I make equal the two name in the macro?
Diagram as Chart 1 (back and forth)
So this is the problem:
Dim z As String
z = "Chart 1" = "Diagram 1"
ActiveSheet.Shapes(z).ScaleWidth 2.3, msoFalse, _
msoScaleFromTopLeft
ActiveSheet.Shapes(z).ScaleHeight 2.9, msoFalse, _
msoScaleFromTopLeft
But it's failing all over the time and I don't know why.
Please help me,
Thank you in advance!
I have got a problem because of the Excel language pack perhaps... I've got a Diagram 1 (hungarian name of the chart) and the Excel macro refers to Chart 1 in the english version of the Excel. In the Hungarian version the macro in the macro record function enter the Diagram 1 name. How could I make equal the two name in the macro?
Diagram as Chart 1 (back and forth)
So this is the problem:
Dim z As String
z = "Chart 1" = "Diagram 1"
ActiveSheet.Shapes(z).ScaleWidth 2.3, msoFalse, _
msoScaleFromTopLeft
ActiveSheet.Shapes(z).ScaleHeight 2.9, msoFalse, _
msoScaleFromTopLeft
But it's failing all over the time and I don't know why.
Please help me,
Thank you in advance!
Last edited: