ActiveCell.Formula Differences

[Yesuslave]

Hi all,

As I am self taught with VB/VBA (and also mainly taught by such kind people as yourselves) I've missed some things that might be common knowledge. One of which is the difference between the different ActiveCell.Formula options in Excel 97. As I can see, there are seven different formula options:
ActiveCell.Formula
.FormulaArray
.FormulaHidden
.FormulaLable
.FormulaLocal
.FormulaR1C1
.FormulaR1C1Local

What are these different things/where can I find out what they each do?

Thanks,
Joshua Wise

[WorkHorse]

Search on each one on Help in the Excel VBA editor (or search MSDN).

In a nutshell: R1C1 means the formula uses R1C1 notation (e.g. R2C3 instead of C2). Local means use the language of the user (French, English, etc.). Hidden means whether the formula is hidden when book is protected. Label sets type of forumla labels to use. Array means, well...it means an array formula. You can read about array formulas and formula labels in the regular Excel help files. :)