Results 1 to 4 of 4

FormulaR1C1 Error

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2012
    Location
    Latvia
    MS-Off Ver
    Excel 2010
    Posts
    8

    FormulaR1C1 Error

    Dear Excel experts,
    I am currently strugling with this problem: I just need to insert a simple formula into an excel cell, but it does not seem to want to work.
    The code:
    Range("O6").offset(0, counter2).Select
    ActiveCell.FormulaR1C1 = "=IF(AND(R[-1]C<>0;RC[-1]>=R1C213);RC[-11];0)"
    The second line gets highlighted and I get Run-time error '1004' (Application-defined or object-defined error)
    To me the formula seems correct so what could possibly be the problem?
    Last edited by wolis; 05-09-2012 at 07:55 AM.

Thread Information

Users Browsing this Thread

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

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