| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Select Case or Best Method
I have a large range of data that can be anywhere from 100 to 500
lines. This range consists of A3:D??. The information in Column B will decide the code to be put in Column A. ie.. IF Column B Then Column A 26 1 26.3 2 27 3 33 4 33.3 5 Continues on to 23. I'm sure it will include a select case and a some type of looping. I would appreciate any help that can be offered here. Thank you, Christina |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Select Case or Best Method
more info would help.
"Christina" wrote in message om... I have a large range of data that can be anywhere from 100 to 500 lines. This range consists of A3:D??. The information in Column B will decide the code to be put in Column A. ie.. IF Column B Then Column A 26 1 26.3 2 27 3 33 4 33.3 5 Continues on to 23. I'm sure it will include a select case and a some type of looping. I would appreciate any help that can be offered here. Thank you, Christina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select case | Excel Discussion (Misc queries) | |||
| Case Select | Excel Worksheet Functions | |||
| Case without Select Case error problem | Excel Discussion (Misc queries) | |||
| Error: method 'select' of object_worksheet' failed | Excel Discussion (Misc queries) | |||
| select case help please | Excel Programming | |||
![Christina[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
