MAcros big Q!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lgarcia - 01 Apr 2004 03:57 GMT

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?

Reply to this Message

mudraker - 01 Apr 2004 04:53 GMT

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

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Dave Hawley - 01 Apr 2004 06:51 GMT

Hi

Try adding the line of code below

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

Reply to this Message

Andy Pope - 01 Apr 2004 09:16 GMT

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

> Hi
>
[quoted text clipped - 6 lines]
> Excel Templates, Training & Add-ins.
> Free Excel Forum http://www.ozgrid.com/forum *****

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message