I have the following subroutine, which works to test cell C1 for a value & write a more descriptive value in D1. But I haven't been able to figure out how to loop it so that it will test column C in every row of the worksheet. Any help with this is much appreciated.
[pre]
[/pre]
[pre]
Code:
Sub LongItemNameForAssets()
Select Case Range("C2").Text
Case "19"
inch = Chr(34)
Range("D2").Value = "HP 19" & inch & " CRT Monitor"
Case "17"
inch = Chr(34)
Range("D2").Value = "HP 17" & inch & " CRT Monitor"
Case "17 Flat Panel Monitor"
inch = Chr(34)
Range("D2").Value = "HP 17" & inch & " Flat Panel Monitor"
Case "19 Flat Panel Monitor"
inch = Chr(34)
Range("D2").Value = "HP 19" & inch & " Flat Panel Monitor"
Case "15"
inch = Chr(34)
Range("D2").Value = "HP 15" & inch & " CRT Monitor"
Case "20 Flat Panel Monitor"
inch = Chr(34)
Range("D2").Value = "HP 20" & inch & " Flat Panel Monitor"
Case "2710p"
Range("D2").Value = "HP 2710p Laptop"
Case "2730p"
Range("D2").Value = "HP 2730p Laptop"
Case "2700 Expansion Base"
Range("D2").Value = "HP 2700 Expansion Base"
End Select
End Sub