upobDaPlaya
asked on
Restrict next record to a specific column for a named range
If have a named range and want to loop thru a specific column of the named range is this possible. Note my defuned name range spans from A1:C300. I want to loop thru Column A and if it matches then take a value found in the same row from column B. Am I just better off not trying to leverage off my Defined Name and instead set the range (Col A) from within the code ?
Dim MyRng as Range
For each MyRng in Range("Produce")
If "Orange" = MyRng THEN
msgBox = MyRng.Offset(0,1)
else
end if
Dim MyRng as Range
For each MyRng in Range("Produce")
If "Orange" = MyRng THEN
msgBox = MyRng.Offset(0,1)
else
end if
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.
ASKER