Excel VBA - How To Insert Plain Value without Formula?

vba excel excel-2003
reforrer picture reforrer · Apr 28, 2011 · Viewed 25.2k times · Source

I have skimmed many Excel VBA topics, however, I have not found any information about inserting plain values - the result of SUM() in this case - not formula. There is a method, PasteSpecial xlPasteValues, but it seems that it is not what I am looking for.

The following code example inserts the formula, not only the value:

Sub test()
    Range("A4").Value = "=SUM(A1:A3)"
End Sub

How do I insert plain values without the formula in Excel VBA?

Answer

shahkalpesh picture shahkalpesh · Apr 28, 2011

Here is what I think, you are looking for

range("a4").Value = Evaluate("SUM(A1:A3)")

Related questions

Loop through each row of a range in Excel

This is one of those things that I'm sure there's a built-in function for (and I may well have been told it in the past), but I'm scratching my head to remember it. How do I loop through each row …

Read More
How to show current user name in a cell?

In most of the online resource I can find usually show me how to retrieve this information in VBA. Is there any direct way to get this information in a cell? For example as simple as =ENVIRON('User') (which did …

Read More
Get User Selected Range

How can I get a range of cells selected via user mouse input for further processing using VBA?

Read More