dwg83
Board Regular
- Joined
- Nov 8, 2006
- Messages
- 174
I am trying to see if a cell has a certain word in it. What do I need to change in the following code:
Thanks
Code:
If ISheet.Cells(i, 2) = "Electricity" Then
FProduct.Cells(i - 1, 2) = "Electric" & emeters
FProduct.Cells(i - 1, 4) = "e"
FProduct.Cells(i - 1, 5) = 3413
FProduct.Cells(i - 1, 6) = 3413
eflag = True
ElseIf ISheet.Cells(i, 2) = "Natural Gas" Then
FProduct.Cells(i - 1, 2) = "Nat Gas" & gmeters
FProduct.Cells(i - 1, 4) = "g"
FProduct.Cells(i - 1, 5) = 100000
FProduct.Cells(i - 1, 6) = 100000
gflag = True
Else
End If
Thanks
Last edited: