Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy question?
I have this code with button on click event and it doesn't work.
Worksheets("Data").Range("A4:C4").Copy ActiveSheet.Paste Destination:=Worksheets("Graph").Range("A2:C2") Worksheets(8).Activate ActiveSheet.ChartObjects(1).Chart.Axes(xlValue).Mi nimumScale = 0 Application.CutCopyMode = False This is only chart in workbook. Error is in line (highlights this line when running code) ActiveSheet.ChartObjects(1).Chart.Axes(xlValue).Mi nimumScale = 0 If someone can help. Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy question?
There should be no error in that line. Perhaps it is NOT the active sheet?
Is sheet(8) also Graph? The sheet does NOT have to be active. Worksheets("Data").Range("A4:C4"). _ Copy Worksheets("Graph").Range("A2:C2") Worksheets(8).ChartObjects(1). _ Chart.Axes(claque).MinimumScale = 0 -- Don Guillett SalesAid Software "Marc" wrote in message ... I have this code with button on click event and it doesn't work. Worksheets("Data").Range("A4:C4").Copy ActiveSheet.Paste Destination:=Worksheets("Graph").Range("A2:C2") Worksheets(8).Activate ActiveSheet.ChartObjects(1).Chart.Axes(xlValue).Mi nimumScale = 0 Application.CutCopyMode = False This is only chart in workbook. Error is in line (highlights this line when running code) ActiveSheet.ChartObjects(1).Chart.Axes(xlValue).Mi nimumScale = 0 If someone can help. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
probably an easy question | Excel Discussion (Misc queries) | |||
Easy VBA question | Excel Discussion (Misc queries) | |||
Easy Question | Excel Discussion (Misc queries) | |||
*EASY* question 2!! | New Users to Excel | |||
new user with easy question? not easy for me | New Users to Excel |