MAcros big Q!

  • Thread starter Thread starter lgarcia
  • Start date Start date
L

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 *****
 
it will help us to answer your question if you ost your code as well a
your questio
 
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
 
Back
Top