Cell reference that pulls value only, not formula

[vijaykumar]

Is there a way to reference a cell to pull only the value? I have a set of bloomberg formulas in one cell and want the result (hardcoded/values only) to be pulled into another cell.

Thanks,
Vijay

 

[barjoman]

You can record a macro to copy and paste values. Are you familiar with macros or would you like more help?

 

[vijaykumar]

I am not too familiar but I have coworkers who are. Is there code you could assist with?

 

[barjoman]

Here is some simple code to do this:

Sub CopyPasteValues()
'
' CopyPasteValues Macro
'
    Range("A1:C3").Select
    Selection.Copy
    Range("E1:G3").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub

A1:C3 is your source range which contains the formulas.
E1:G3 is your target range which will contain the values.

You can adjust either of these ranges to suit your needs.