Richard in Redditch
New Member
- Joined
- Feb 7, 2012
- Messages
- 44
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
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