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
|