Amanda_Jones81
New Member
- Joined
- Nov 11, 2020
- Messages
- 3
- Office Version
- 2010
- Platform
- Windows
I am trying to use VBA code to reference the minimum value in a range of cell across a row and then reference another cell corresponding to that minimum value and then display in a msg box.
example:
find minimum value in range E34:Q34
once minimum value is found in above range- identify the coressponding specific cell with string value in range E22:Q22 that is in the same column as that minimum value that was found.
then the string value in range E22:Q22 is displayed in a msgbox statement.
example:
find minimum value in range E34:Q34
once minimum value is found in above range- identify the coressponding specific cell with string value in range E22:Q22 that is in the same column as that minimum value that was found.
then the string value in range E22:Q22 is displayed in a msgbox statement.