"Sheet(1)" Syntax

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

can someoen remind me what this syntax means:

Sheets(1).ChartObjects(1).Chart

Is this referencing the first sheet (i.e. left to right in window)?

Thanks

EM
 
Yes it is. If the sheet is moved, its index changes.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding Data points Equal to Zero 4
Update "centerheader" code running slowly need help speeding up 7
.Seriescolection(n).formula - size limitation? 5
Protecting Embedded Chart 1
Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is p 5
Excel 2003 code to use instead of ChartObjects 4
Create several charts in one go using VBA 4
Excel to Powerpoint 2003 Chart Width 2

Back
Top