Hi all
I would like this code to return the value into the d7, not the formula
Range("d7") = "=(VLookup(0, myrange, 3, False))"
currently I am add the following but it is cumbersome
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
ActiveSheet.Paste
Application.CutCopyMode = False
tia
I would like this code to return the value into the d7, not the formula
Range("d7") = "=(VLookup(0, myrange, 3, False))"
currently I am add the following but it is cumbersome
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
ActiveSheet.Paste
Application.CutCopyMode = False
tia