Several people have helped me get to the stage where I've got the following formulae working:

Range("B6").Formula = "=max(h1:h300)"
Range("B7").Formula =
"=(CELL("address",OFFSET(h1,MATCH(MAX(h1:h300),h1:h300,0)-1,0)))"
Range("B8").Formula = "=ROW(OFFSET(A1,COUNTA(A:A)-1,0))"

next question is for my 3 formulae, how do i set a variable to equal each of those values for writing to a sequential text file?

TIA,

Rob