odd_socks17
06-22-2017, 02:17 AM
Hi all,
Looking for a vba method of assigning the row value of a cell, where a formula returns a "true" value, to a variable. I've attached a sample image of my database, row "AD" will be hidden when using the database and contains a match formula (can provide code if needed) which will only returns TRUE in one row of the entire database (as there are no duplicate values). I need a way of getting the row number of that "true" and assigning it to a variable so i can use it to identify another cell in the same row (can provide code if needed).
19568
Any and all help appreciated, thanks ex(cel)perts! :)
Looking for a vba method of assigning the row value of a cell, where a formula returns a "true" value, to a variable. I've attached a sample image of my database, row "AD" will be hidden when using the database and contains a match formula (can provide code if needed) which will only returns TRUE in one row of the entire database (as there are no duplicate values). I need a way of getting the row number of that "true" and assigning it to a variable so i can use it to identify another cell in the same row (can provide code if needed).
19568
Any and all help appreciated, thanks ex(cel)perts! :)