Insert VBA function into a cell where the address differs each time.

[Richard in Redditch]

Hello
I have an application where I am trying to insert a formula into a cell, the address of which will alter each time through. The code I am trying to use is this:
ActiveCell.Formula = "=summary! & Cells(LastRowNo + 1, 5)". This is not correct, but I hope it shows what I am trying to. Any help will be appreciated.
Thanks
Richard

 

[John_w]

Maybe:

    ActiveCell.Formula = "=summary!" & Cells(LastRowNo + 1, 5).Address

 

[mikerickson]

Perhaps something like

dim SomeRange as Range

Set SomeRange=Worksheets("Summary").Range("A65536").End(xlUp)

Worksheets("other").Range("A1").Formula = "=" & SomeRange.Address(,,,True)

 

[Richard in Redditch]

Hello
A very big "thank you" to everybody who has helped me out with the answer to my query. I did accidentally post it twice - I thought I had not got it right the first time, so apologies to anyone who thought I was taking the mickey. What a wonderful forum!
Richard