| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code for IF B1 < "" then C1="FILLED"
Thank you all - very helpful!!!!
"Bob Phillips" wrote: Dim iLastRow As Long Dim i As Long iLastRow = Cells(Rows.Count, "B").End(xlUp).Row For i = 1 To iLastRow If Cells(i, "B").Value < "" Then Cells(i, "C").Value = "FILLED" End If Next i -- HTH Bob Phillips "Diane" wrote in message ... I have a column that has a random number of entries in it (sometimes cell B1-B20 are filled sometimes B1-B4 are filled, etc). I am looking to write a macro that when run, will check to see if there is a value in column B, and if so, fill the corresponding cell in Column C with "FILLED" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Looking for VB code to test for "RING" , "BUSY" disconnects or other signals | Excel Programming | |||
Threaded Mode
