Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi;
I'm new to VBA and need to get A LOT done quickly. I need help with some simple code for the following: I have a sheet with a column (~1500 rows) in which each cell contians a numeric value. I want to create a new column in which cell contains a text string based on the numeric value in the first column; i.e.: If A1 < 0, then B1="string1" If A1 =0, then B1="string2" and so on for all cells in column. Any help, suggestions? Thanks in advance, -jbb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
option buttons run Click code when value is changed via VBA code | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |