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