Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
any value to range.formula
Is there any advantage to setting a cell's contents using range.formula vs
range.value? The following yield identical results: Sub place_it() s = "=1+2" Range("A1").Value = s Range("A2").Formula = s End Sub -- Gary's Student gsnu200705 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
any value to range.formula
Except for clarity of what you are doing, apparently not but I often like to
just leave the value Sub place_it() s = "=1+2" 'Range("A1").Value = s Range("a1").Value = Application.Sum(1, 2) 'or Range("a1").Value = 1 + 2 Range("A2").Formula = s -- Don Guillett SalesAid Software "Gary''s Student" wrote in message ... Is there any advantage to setting a cell's contents using range.formula vs range.value? The following yield identical results: Sub place_it() s = "=1+2" Range("A1").Value = s Range("A2").Formula = s End Sub -- Gary's Student gsnu200705 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
Macro to input formula in range based on another range | Excel Programming | |||
Range.Formula and Range question using Excel Automation | Excel Programming |