Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel vba problem
Hi All,
I'm trying, using a VBA macro, to set the ChartArea.Height property of an Excel Graph object but I'm getting the following error: Run-time error '1004': Unable to set the Height of the ChartArea class According to the MSDN documentation the Width is a read-write My code is below. If anyone can shed some light on this it would be greatly appreciated. I'm using Excel Small Business 2003 Regards, Patrick Sub Macro1() '' Dim hauteur As Double ' hauteur = 400# ActiveSheet.ChartObjects("Graphique 1").Activate ActiveChart.ChartArea.Select ActiveChart.ChartArea.Height = hauteur End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |