I have the need in Excel vba to find a value within a range that will change. I want to start my find in cell B3 and continue to look down column B for a specific word. When it finds that word i want to set a variable in my code for that cell. I want it to continue to look down from B3 until it hits a blank cell. When it hits the blank cell i also want to record a variable for that blank cell.