Hi all,
How can I refer to a range with INDIRECT without using VBA? The range I want to refer to is:
e.g.
where "CST" changes depending on the selection in my ComboBox.
Please Login or Register to view this content.
Please Login or Register to view this content.
If you are referring to a named range, why bother with INDIRECT?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Because I have 100+ named ranges and want to refer to the one that is relevant (depending on what is selected in my combo boxes).
e.g.
FY18_JPN_DTC_CST
FY18_JPN_DTC_RTL
FY18_JPN_DTC_UNT
FY18_KOR_DTC_CST
FY18_KOR_DTC_RTL
FY18_KOR_DTC_UNT
etc...
Is your combobox linked to a cell?
Don
Please remember to mark your thread 'Solved' when appropriate.
Yes! It is linked to a cell...
Then the formula should be
=SUMIFS(INDIRECT("FY18_JPN_DTC_"&A1),Category,"PANT",Attribute,"BLUE"))
or whatever the linked cell is
Ups... just realised, my named range "Selected_Metric" was slightly off, so it was giving me a #REF. It's working fine now! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks