range.formula

[ammartino44]

Hello. Do I have to do range.formula for a formula? or Can I just write "=" and the write formula.

[walruseggman]

You don't "have" to use .Formula, just like you don't have to use .Value, even though it's good practice.

For example, if I have 1 in A1, and 2 in A2, the following code would show 3 in A3:

Please Login or Register  to view this content.

[shg]

It's very bad practice to omit the property. Just recently on the forum someone got bit trying to insert an R1C1 formula using the (default) Value property -- which will work as long as the formula is unambiguously R1C1:

Please Login or Register  to view this content.

Unfortunately, if it can be interpreted as A1, it will be (and it was):

Please Login or Register  to view this content.

Relying on default properties, or using the wrong property, are hallmarks of an amateur. You don't wanna be that.

[FDibbins]

Words to live by, shg, thanks

[shg]

WTY, Ford

[Philb1]

To hard to understand, that's the main reason I don't use R1C1. I can work it out if I have to, but why bother