Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with Arrays, pasing from function to function
First let me explain the big picture. I'm trying to make a function to look
at list of zipcodes. They are listed in this format "Augusta GA" "298, 308-310". City name in one cell and the zips in another. I want the function to look at these entries and tell me if a certain zipcode is in the list. For example if I enter a zip of 309 it should return Augusta GA. Now, I'm at the point where I have made a function to fill the range into an array. The functions leaves me with an array of (308, 309, 310). I have two questions. First of all is the best way to approach this? Second if so, what do I need to know about passing arrays from one function to another. Thanks Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
Using function with Arrays | Excel Programming | |||
Using arrays or range in IF function - HELP PLS | Excel Worksheet Functions | |||
Arrays and Join Function | Excel Programming | |||
Help with a UDF Function using Arrays... | Excel Programming |