John Davis
Well-known Member
- Joined
- Sep 11, 2007
- Messages
- 3,457
Hello All:
I'm getting the title error in the following code. Range("W" & i).Value...... line is highlighted:
Dim i As Integer
For i = 2 To 10000
If Range("V" & i).Value = "3701.30.0000" Then
Range("K" & i).Formula = _
"=VLOOKUP(L & i,'[CONVERSION FACTORS PLATES.xls]import'!$A$2:$B$10000,2,FALSE)"
Range("W" & i).Value = Range("K" & i).Value * Range("R" & i).Value
End If
Next i
Can anyone offer any help??
I'm getting the title error in the following code. Range("W" & i).Value...... line is highlighted:
Dim i As Integer
For i = 2 To 10000
If Range("V" & i).Value = "3701.30.0000" Then
Range("K" & i).Formula = _
"=VLOOKUP(L & i,'[CONVERSION FACTORS PLATES.xls]import'!$A$2:$B$10000,2,FALSE)"
Range("W" & i).Value = Range("K" & i).Value * Range("R" & i).Value
End If
Next i
Can anyone offer any help??