+ Reply to Thread
Results 1 to 2 of 2

what is the activecell.FormulaR1C1 method

  1. 06-23-2015, 05:11 AM #1
    kisanvikas2015
    kisanvikas2015 is offline
    Registered User
    Join Date
    04-14-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    127

    what is the activecell.FormulaR1C1 method

    Hi everyone,

    Can anyone help me what is

    ActiveCell.FormulaR1C1 = "=SUMIF(R10C[-1]:R[-1]C[-1],R[-3]C[-1],R10C:R[-1]C)"

    What is the difference between normal vba formula v vba R1C1formula?

    Regards,
    Vikas
    Reply With QuoteRegister To Reply
  2. 06-23-2015, 06:30 AM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: what is the activecell.FormulaR1C1 method

    Maybe:

    http://excel.tips.net/T003010_Unders...eferences.html
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Customize ActiveCell.FormulaR1C1
    By smartbuyer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2013, 10:46 PM
  2. Concatenating literal, with ActiveCell and FormulaR1C1
    By LydiasDad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2011, 06:40 PM
  3. ActiveCell.FormulaR1C1 Dynamic Row
    By goldenbear10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2009, 04:47 AM
  4. [SOLVED] SumIf in ActiveCell.FormulaR1C1 ?
    By RitaP in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2006, 02:20 PM
  5. ActiveCell.FormulaR1C1 Sum Function
    By mb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2005, 07:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1