How can I refer to different rows in a range and include the cell addresses
into a formula being entered onto a sheet by macro?

What I'm trying to do is:

- Range = a1:m100 of another sheet
- formula: .Range("A49").FORMULA = "=LOOKUP(cells in first row in range)"
- more code in a loop
- back to start of loop
- formula: .Range("A49").FORMULA = "=LOOKUP(cells in second row in range)"
- and so on...

I hope this makes sense - the code is very long and detailed and only need
help with this small (but crucial!!) part...

TIA