+ Reply to Thread
Results 1 to 3 of 3

multiplication formula in vba

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    multiplication formula in vba

    hello. I used the vba recorder for a formula and it returned this. Is this the standard way of writing formulas?


    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,326

    Re: multiplication formula in vba

    It is one of the two "standard" spreadsheet notations. the default spreadsheet notation is A1 notation, that tends to be more popular. Less popular, but still common, is R1C1 notation. (see here https://support.office.com/en-us/art...es_in_formulas for a discussion of the different reference styles).

    R1C1 notation can be particular useful in VBA, because the formula text string is the same, no matter what cell you put the formula in (especially for relative references). If you use A1 notation, you would need to have several statements to manipulate A1 notation formulas, but in R1C1 notation, you create the formula string once, then write it in wherever needed.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Re: multiplication formula in vba

    Eu entendi. Obrigado.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 03-13-2015, 01:44 PM
  2. [SOLVED] Formula that goes from multiplication to plus at a set value
    By RMGHOLDUR in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-19-2014, 02:21 PM
  3. [SOLVED] VBA Multiplication Formula
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-19-2013, 04:32 AM
  4. What formula to use the multiplication
    By macroashraf in forum Excel General
    Replies: 5
    Last Post: 05-24-2012, 10:36 AM
  5. Multiplication formula
    By yuvosh in forum Excel General
    Replies: 5
    Last Post: 03-05-2007, 08:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1