Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart & Active Sheet
Hello All:
I am making a chart via code, am having a bit of problem. I am trying to insert ActiveSheet which should pick the name of the tab but am getting error"Method Location Of Object Chart Failed". My Current Code Is: co.Chart.Location Whe=xlLocationAsObject, Name:="ActiveSheet" ActiveSheet suppose to insert the tab name, May be I am doing something wrong. Any suggestion Regards Ardy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart & Active Sheet
On Feb 7, 7:52 pm, "Ardy" wrote:
Hello All: I am making a chart via code, am having a bit of problem. I am trying to insert ActiveSheet which should pick the name of the tab but am getting error"Method Location Of Object Chart Failed". My Current Code Is: co.Chart.Location Whe=xlLocationAsObject, Name:="ActiveSheet" ActiveSheet suppose to insert the tab name, May be I am doing something wrong. Any suggestion Regards Ardy Ops Got the Syntex co.Chart.Location Whe=xlLocationAsObject, Name:=ActiveSheet.Name |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart & Active Sheet
Post a couple lines of code leading up to this. Are you inserting the chart
object on the active sheet? Then you don't need to change its location to the active sheet, as it's already there. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Ardy" wrote in message oups.com... On Feb 7, 7:52 pm, "Ardy" wrote: Hello All: I am making a chart via code, am having a bit of problem. I am trying to insert ActiveSheet which should pick the name of the tab but am getting error"Method Location Of Object Chart Failed". My Current Code Is: co.Chart.Location Whe=xlLocationAsObject, Name:="ActiveSheet" ActiveSheet suppose to insert the tab name, May be I am doing something wrong. Any suggestion Regards Ardy Ops Got the Syntex co.Chart.Location Whe=xlLocationAsObject, Name:=ActiveSheet.Name |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to sort an active sheet using the col of the active cell | Excel Programming | |||
Copy my active sheet to a new sheet and open with an input form | Excel Programming | |||
Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
How to make chart embedded in active sheet? | Excel Programming | |||
Test for presence of chart on active sheet | Excel Programming |