Results 1 to 2 of 2

Problem whit SUMIFS R1C1 Formula !

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Kiruna
    Posts
    163

    Problem whit SUMIFS R1C1 Formula !

    Hi

    I am trying to add this formula trough VBA to a cell but gets an #NAME? Error, but when i click in the formula bar and press enter i works perfectly.
    I want it to work directly the VBA put it in the cell ?

    Worksheets("Blad1").Cells(7 + ((x - 1) * 19), 3).FormulaR1C1 = "=SUMIFS(Budget_Kredit!R[-6]C:R[993]C,Budget_Kredit!R[-6]C[-1]:R[993]C[-1],Settings!R[-6]C[-2])"

    Best regards

    Petter
    Last edited by Petter120; 03-12-2012 at 09:36 PM.

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