Sir Babydum GBE
12-24-2017, 04:59 PM
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
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
How do I do it please?
Many thanks
Sir BD
Trouble is, I want the code to put the value in there, not the formula
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
How do I do it please?
Many thanks
Sir BD