what i am trying to do is look thru a spreadsheet by columns and find a value. if that value is found then i need to know what the cell refrence is so that i can add a row beneth it so i can do subtotals under it. the find works but i don't know what the statement is for cell refrence. i know =address(rows(),columns()) would work in a formula.
thanks in advance
thanks in advance