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)
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.