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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Chart refers to a Named Range with Offset formula in a closed workbook - MS Excel 2010
Thanks, I will take a look at this and see what I can do - I was hoping for another way besides VBA, but I will see what I can do. I appreciate the feedback.- westma32
- Post #3
- Forum: Microsoft: Office
-
Chart refers to a Named Range with Offset formula in a closed workbook - MS Excel 2010
I am using Named ranges in a workbook (titled Workbook1), which uses the Offset formula to reference a dynamic range. For example, The Named range is CategoryY, and it refers to the formula =OFFSET('Sheet1'!$A$1,1,0,COUNTA('Sheet1'!$A:$A)-1,1). In another workbook (titled Workbook2), I have a...- westma32
- Thread
- Replies: 3
- Forum: Microsoft: Office
