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