Range() is not working when using a long string variable
I am trying to create a chart in Excel using this VBA. I am using this code:
myRange = "Sheet1!$A1,ドルSheet1!$A3,ドルSheet1!$A8,ドルSheet1!$A13,ドルSheet1!$A18,ドルSheet1!$A23,ドルSheet1!$A28,ドルSheet1!$A34,ドルSheet1!$A41,ドルSheet1!$A48,ドルSheet1!$D1,ドルSheet1!$D3,ドルSheet1!$D8,ドルSheet1!$D13,ドルSheet1!$D18,ドルSheet1!$D23,ドルSheet1!$D28,ドルSheet1!$D34,ドルSheet1!$D41,ドルSheet1!$D48ドル"
ActiveSheet.Shapes.AddChart2(227, xlLine).Select
ActiveChart.SetSourceData Source:=Range( _
myRange _
)
It is working as it is, but whenWhen I add another couple of cells into the myRange variable (...,Sheet1!$A55ドル... ,Sheet1!$D55ドル), like this:
myRange = "Sheet1!$A1,ドルSheet1!$A3,ドルSheet1!$A8,ドルSheet1!$A13,ドルSheet1!$A18,ドルSheet1!$A23,ドルSheet1!$A28,ドルSheet1!$A34,ドルSheet1!$A41,ドルSheet1!$A48,ドルSheet1!$A55,ドルSheet1!$D1,ドルSheet1!$D3,ドルSheet1!$D8,ドルSheet1!$D13,ドルSheet1!$D18,ドルSheet1!$D23,ドルSheet1!$D28,ドルSheet1!$D34,ドルSheet1!$D41,ドルSheet1!$D48,ドルSheet1!$D55ドル"
It stops working and gotI get this error:
Run-time error '1004' Method 'Range' of object '_Global' failed
Could you please help me? Thanks
Run-time error '1004'
Method 'Range' of object '_Global' failed
Range() is not working when using a string variable
I am trying to create a chart in Excel using VBA. I am using this code:
myRange = "Sheet1!$A1,ドルSheet1!$A3,ドルSheet1!$A8,ドルSheet1!$A13,ドルSheet1!$A18,ドルSheet1!$A23,ドルSheet1!$A28,ドルSheet1!$A34,ドルSheet1!$A41,ドルSheet1!$A48,ドルSheet1!$D1,ドルSheet1!$D3,ドルSheet1!$D8,ドルSheet1!$D13,ドルSheet1!$D18,ドルSheet1!$D23,ドルSheet1!$D28,ドルSheet1!$D34,ドルSheet1!$D41,ドルSheet1!$D48ドル"
ActiveSheet.Shapes.AddChart2(227, xlLine).Select
ActiveChart.SetSourceData Source:=Range( _
myRange _
)
It is working as it is, but when I add another couple of cells into the myRange variable (...,Sheet1!$A55ドル... ,Sheet1!$D55ドル), like this:
myRange = "Sheet1!$A1,ドルSheet1!$A3,ドルSheet1!$A8,ドルSheet1!$A13,ドルSheet1!$A18,ドルSheet1!$A23,ドルSheet1!$A28,ドルSheet1!$A34,ドルSheet1!$A41,ドルSheet1!$A48,ドルSheet1!$A55,ドルSheet1!$D1,ドルSheet1!$D3,ドルSheet1!$D8,ドルSheet1!$D13,ドルSheet1!$D18,ドルSheet1!$D23,ドルSheet1!$D28,ドルSheet1!$D34,ドルSheet1!$D41,ドルSheet1!$D48,ドルSheet1!$D55ドル"
It stops working and got this error:
Run-time error '1004' Method 'Range' of object '_Global' failed
Could you please help me? Thanks
Range() using a long string variable
I create a chart in Excel using this VBA.
myRange = "Sheet1!$A1,ドルSheet1!$A3,ドルSheet1!$A8,ドルSheet1!$A13,ドルSheet1!$A18,ドルSheet1!$A23,ドルSheet1!$A28,ドルSheet1!$A34,ドルSheet1!$A41,ドルSheet1!$A48,ドルSheet1!$D1,ドルSheet1!$D3,ドルSheet1!$D8,ドルSheet1!$D13,ドルSheet1!$D18,ドルSheet1!$D23,ドルSheet1!$D28,ドルSheet1!$D34,ドルSheet1!$D41,ドルSheet1!$D48ドル"
ActiveSheet.Shapes.AddChart2(227, xlLine).Select
ActiveChart.SetSourceData Source:=Range( _
myRange _
)
When I add another couple of cells into the myRange variable (...,Sheet1!$A55ドル... ,Sheet1!$D55ドル), like this:
myRange = "Sheet1!$A1,ドルSheet1!$A3,ドルSheet1!$A8,ドルSheet1!$A13,ドルSheet1!$A18,ドルSheet1!$A23,ドルSheet1!$A28,ドルSheet1!$A34,ドルSheet1!$A41,ドルSheet1!$A48,ドルSheet1!$A55,ドルSheet1!$D1,ドルSheet1!$D3,ドルSheet1!$D8,ドルSheet1!$D13,ドルSheet1!$D18,ドルSheet1!$D23,ドルSheet1!$D28,ドルSheet1!$D34,ドルSheet1!$D41,ドルSheet1!$D48,ドルSheet1!$D55ドル"
I get this error:
Run-time error '1004'
Method 'Range' of object '_Global' failed
Range() is not working when using a string variable
I am trying to create a chart in Excel using VBA. I am using this code:
myRange = "Sheet1!$A1,ドルSheet1!$A3,ドルSheet1!$A8,ドルSheet1!$A13,ドルSheet1!$A18,ドルSheet1!$A23,ドルSheet1!$A28,ドルSheet1!$A34,ドルSheet1!$A41,ドルSheet1!$A48,ドルSheet1!$D1,ドルSheet1!$D3,ドルSheet1!$D8,ドルSheet1!$D13,ドルSheet1!$D18,ドルSheet1!$D23,ドルSheet1!$D28,ドルSheet1!$D34,ドルSheet1!$D41,ドルSheet1!$D48ドル"
ActiveSheet.Shapes.AddChart2(227, xlLine).Select
ActiveChart.SetSourceData Source:=Range( _
myRange _
)
It is working as it is, but when I add another couple of cells into the myRange variable (...,Sheet1!$A55ドル... ,Sheet1!$D55ドル), like this:
myRange = "Sheet1!$A1,ドルSheet1!$A3,ドルSheet1!$A8,ドルSheet1!$A13,ドルSheet1!$A18,ドルSheet1!$A23,ドルSheet1!$A28,ドルSheet1!$A34,ドルSheet1!$A41,ドルSheet1!$A48,ドルSheet1!$A55,ドルSheet1!$D1,ドルSheet1!$D3,ドルSheet1!$D8,ドルSheet1!$D13,ドルSheet1!$D18,ドルSheet1!$D23,ドルSheet1!$D28,ドルSheet1!$D34,ドルSheet1!$D41,ドルSheet1!$D48,ドルSheet1!$D55ドル"
It stops working and got this error:
Run-time error '1004' Method 'Range' of object '_Global' failed
Could you please help me? Thanks