Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Array
Hi, I haven't used arrays in a while so forgive me. I'm converting numeric
values that represent the U.S. states into the text values. If B1 = 1, then A1.value = NC, If B1 = 5, then A1.value = SC. I was making a case structure for this, but this will take me forever because I need to check every state AND I need to check the entire column "B"! I realized an array would be better, but I can't remember how to build them correctly. Here is the case structure I was making: Sub EntityCheck() Select Case Range("B2").Value Case 1 Range("A2").Value = "NC" Case 5 Range("A2").Value = "SC" Case 35 Range("A2").Value = "NJ" Case 75 Range("A2").Value = "FL" Case 99 Range("A2").Value = "TX" Case 172 Range("A2").Value = "GA" End Select I appreciate any help you can offer! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Array | Excel Discussion (Misc queries) | |||
[HELP WITH ARRAY] Simple for you, very hard for me....please | Excel Programming | |||
Simple Array Looping | Excel Programming | |||
Simple Array question | Excel Programming | |||
Simple Array question | Excel Programming |