Results 1 to 2 of 2

Thread: ActiveCell.Formula Differences

  1. Oct 9th, 2003, 02:32 PM #1
    Yesuslave
    Yesuslave is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2003
    Location
    Mt. Holly, NJ
    Posts
    31

    ActiveCell.Formula Differences

    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
    Reply With Quote Reply With Quote
  2. Oct 9th, 2003, 05:46 PM #2
    WorkHorse
    WorkHorse is offline
    Fanatic Member WorkHorse's Avatar
    Join Date
    Jul 2002
    Location
    Where you live.
    Posts
    591
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width