Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel chart to wrong worksheet?

Status
Not open for further replies.
MePenguin

MePenguin

Technical User
Oct 31, 2003
107
SE
Could anyone tell me under which circumstances the following will not work?

Code: 
ObjExChart.Location xlLocationAsObject, "Graphs"

I have the line in a module that draws a couple of charts, moving the chart to the "Graphs" worksheet when drawn.
If I just have 2 worksheets, then it works fine - with more then it moves the chart to the last worksheet created, and the next bit of code fails because the chart isn't where it should be...

thanks

Phil
 
Status
Not open for further replies.

Similar threads

Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
522
Viswa.R
Viswa.R
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
770
Andrzejek
Andrzejek
hermanlaksko
  • Locked
  • Question
Convert PDF file to text
Replies
6
Views
483
hermanlaksko
hermanlaksko
breezett93
  • Locked
  • Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open 1
Replies
14
Views
1K
dhookom
dhookom
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel (early binding) 1
Replies
2
Views
1K
Knicks
Knicks

Part and Inventory Search

Sponsor

Back
Top