upobDaPlaya
asked on
Why does attempted match on a loop provide incorrect evaluation
Why does a an empty cell in a a named range = a non blank cell. I am attempting to match cells in the data tab vs the named range and for some reason if the named range is blank it thinks it equals a cell from the data tab with a value of "orange" as an example. I on purpose had my range in the named range exceed the cells where I have values in the event I later add to the named range..
Sub LoopData()
Dim intD As Integer
Dim intE As Integer
Dim lastrow As Integer
Dim lr As Range
Dim strProd As String
intD = Sheets("Data").Range("A" & Rows.Count).End(xlUp).Row
For d = 2 To intD
strProd = Sheets("Data").Range("A" & d)
For Each lr In Range("ItemFocus")
If strproduct = lr.Value Then
MsgBox (lr.Value)
Else
End If
Next lr
Next d
End Sub
ee-loop.xlsm
Sub LoopData()
Dim intD As Integer
Dim intE As Integer
Dim lastrow As Integer
Dim lr As Range
Dim strProd As String
intD = Sheets("Data").Range("A" & Rows.Count).End(xlUp).Row
For d = 2 To intD
strProd = Sheets("Data").Range("A" & d)
For Each lr In Range("ItemFocus")
If strproduct = lr.Value Then
MsgBox (lr.Value)
Else
End If
Next lr
Next d
End Sub
ee-loop.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER