Hi, the following code places a formula in a cell for me which returns the desired result.
Trouble is, I want the code to put the value in there, not the formula
How do I do it please?Sub LookupTalkNumber() Dim TalkNumber$ 'get the talk number that was just entered TalkNumber = Format(ActiveCell.Value, "0") Cells(53, ActiveCell.Column).Formula = "= vlookup(" & TalkNumber & ", PublicTalkTitles!$A$2:$K$201, 11, FALSE)" End Sub
Many thanks
Sir BD