MAcros big Q!

[lgarcia]

i got a Q, i know pretty much about using the formulas in excel, but
still too rookie using macros, so i got a Q about it.

i made a macro, the result is a graphic char, when i record the macro i
folow all the steps to create the char, and specify the chart has to be
in the same SHEET, i mean not in a new one, and finally i get my chart
and stop the macro.

when i try to run the macro in a new doc, it works, but the chart
appears in a new sheet, anyone knows about that?

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[mudraker]

it will help us to answer your question if you ost your code as well a
your questio

 

[Dave Hawley]

Hi

Try adding the line of code below

ActiveChart.Location Where:=xlLocationAsObject,
Name:=ActiveSheet.Name

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Andy Pope]

Hi Dave,

If its a chartsheet then the activesheet.name will be the chart itself.
I think you need to modify the location name to the required worksheet.

ActiveChart.Location Where:=xlLocationAsObject, Name:=Sheet1.Name

If you still have problems lgracia then post back including the code.

Cheers
Andy