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.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option
David Miller (dlmille)
Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…