Is there a way to dynamicaly assign an array based on cell values? For example in the attached spreadsheet would there be a way to assign an array to each group of cells between the header rows?
Is there a way to dynamicaly assign an array based on cell values? For example in the attached spreadsheet would there be a way to assign an array to each group of cells between the header rows?
Last edited by chad portman; 09-26-2012 at 11:55 AM.
Its not clear what your wanting to do? What do you want to do with an array?
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Try these Dynamic Named Ranges to start with
1/. GroupCodes_A
Refers to
Formula:Please Login or Register to view this content.
2/. GroupCodes_B
Refers to
Formula:Please Login or Register to view this content.
3/. GroupCodes_C
Refers to
Formula:Please Login or Register to view this content.
4/. GroupCodes_D
Refers to
Formula:Please Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
chad portman,
Yes this can be done. As this is in the Excel Programming / VBA / Macros section, I'm assuming you're looking for VBA code. This code will get each section you're looking for you and display the range address.
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you guys.
yes tigeravatar i was looking for code i should have mentioned that i guess. I will try this when i get back to the office and let you know if it works.
Ok so tigeravatar's code does define the ranges perfectly but mike7952 makes a point I guess I should explain what I am tryign to do a little better. I have a spreadsheet with account numbers in col A and tier in Col B I am wanting to write a macro that will place all coupons next to the each account based on their tier. I have another post on this site where I tried to explain it but got no responses. I will link that post below as well re-attach both of spreedsheets to see if you guys can help.
http://www.excelforum.com/excel-prog...html?p=2943807
Again thanks for all your help.
chad portman,
This is designed to be run from the Sample2 workbook. The reason it is 1 to 62, is to accommodate up to 20 coupon offers:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks