Richard in Redditch
New Member
- Joined
- Feb 7, 2012
- Messages
- 44
Hello.
I have an application where I want to put a formula in one sheet of a workbook where the formula addresses another sheet. I am trying to use code such as this:
ActiveCell.Formula = "=summary! & Cells(LastRowNo + 1, 5)". Although I know this syntax is incorrect, I hope it is sufficiently apparent so that my intention is clear. Please can anyone help?
Richard
I have an application where I want to put a formula in one sheet of a workbook where the formula addresses another sheet. I am trying to use code such as this:
ActiveCell.Formula = "=summary! & Cells(LastRowNo + 1, 5)". Although I know this syntax is incorrect, I hope it is sufficiently apparent so that my intention is clear. Please can anyone help?
Richard