Need help on VBA Programming

[mchow2469]

Hi, I am very new to VBA programming. I only understand the fundamentals such as function/variable declaration and usage.

Anyways, I am currently trying to write a VBA program with Excel to append already existing charts. Anyways, I was wondering if anyone can suggest a useful link on how to create/manipulate charts in VBA. More specifically I am using embedded charts.

Currently I am trying to figure out the add method. I understand when creating embedded charts, you need to use the add method and specify the specific location for the newly created chart.
Here is the code where the compiler is saying the subscript is out of range:
Sheets("Create Chart").ChartObjects.Add Left:=50, _
Top:=50, Width:=500, Height:=350

Can anyone explain to me how the dimensions go about in relation to the excel sheet? Thank you very much for your time.

-Mike

[BrianB]

The best way of starting is to record macros whilst doing things manually, you have then got some code that you can change.