Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |