Basic question about Excel Macros and Visual Basic

[Hannibal]

I have a macro in Excel that takes some input on data ranges and produces charts based on the input. I want to place those charts (a number of them are generated) at a certain point in my excel worksheet. I know I can nudge it over by a certain amount but I can never tell where Excel will place them so I would like to just say "hey chart, sit here". Being able to do that in relation to cells would be great. Also, I would like to know if there is any way to resize the chart without using the percent. Once again, in realtion to cells would be great. Thanks for your help.

[Nitzan Aviram]

Hye man
I think I am able to help you but my english is not very good and I dont think i have understood u right. So if you want have a chat with me on 18911790(ICQ).
If you want to refer to a certain cell use the cells property:
Dim str as string
str = ActiveSheet.Cells(2, 5).value
OR...
str = Sheets("Sheet1").Cells(2, 5).value
OR
ActiveSheet.Range("A1:B3")....
OR
ActiveCell....


Form Niztan Aviram.
Any help whould be highly appreciated.

[Hannibal]

Right, I know the cell properties, but is there any way I can tell a chart to go to a specific place in the spreadsheet? For instance, can I say "ActiveChart, move to cell A1" and have the chart line up with A1? That's what I'm looking to do. Thanks