hey guys ,
please I need your help , I have list of EUROPEAN CITIES, ASIAN CITIES, AMERICAN CITIES
I am using space between two word with this formula
=INDIRECT(SUBSTITUTE(A2," ","_"))
A4 being the first cell with validation and B4 with city names
but it doesn't work, please attached find the worksheet
thanks
Antonio
Have you created (Dynamic) Named Ranges for each of those lists?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This is a continuation of this thread...
http://www.excelforum.com/excel-form...menu-list.html
that is the fomula that DBY supplied you with that you did not even acknowledge?
I am closing this thread, you may continue on the other 0ne...and a thank you to DBY for the help they have provided you with so far, would be a good gesture
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks