+ Reply to Thread
Results 1 to 1 of 1

VBA error 1004 when trying to assign formulas to cells

  1. #1
    Registered User
    Join Date
    07-21-2020
    Location
    Washington, DC
    MS-Off Ver
    365
    Posts
    20

    VBA error 1004 when trying to assign formulas to cells

    I'm trying to assign formulas to cells to sum values from a column based on the group that those values belong to. I tried putting the formula directly on the cells but the ranges in the formula kept changing every time I ran my macro so I decided to have the formulas in my VBA code. However, whenever I try to run it, it gives me a error 1004. I'm using excel version 1908 excel proplus. I'd appreciate any help with trying to get rid of this error in my vba code or trying to get the formula in the cells to not change range whenever the macro runs. I put my desired sample output in the sheet called line 1. Thanks in advance.
    Attached Files Attached Files
    Last edited by planjb; 07-27-2020 at 02:23 PM.

+ 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. [SOLVED] Runtime error '1004' on one sheet while trying to change formulas to values
    By BrokenDome in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2019, 10:15 AM
  2. [SOLVED] Rows(Cells(), Cells()) run-time error 1004
    By art3mis in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-22-2019, 02:17 PM
  3. [SOLVED] Formulas in VBA runtime Error 1004
    By shogunatwork in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2017, 10:41 AM
  4. [SOLVED] Range(Cells(a,b),Cells(c,d)) Only Works if Sheet is Active?? (Error 1004)
    By Merf in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-15-2015, 06:03 PM
  5. [SOLVED] error 1004 using the cells
    By RoOmIE in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 10-08-2013, 03:21 PM
  6. range(cells(),cells()) from 2 different workbooks, run time error 1004
    By sam0287 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2010, 05:46 AM
  7. Worksheet.Range(Cells(r,c),Cells(r,c)) & error 1004
    By onebir in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2007, 05:10 AM

Tags for this Thread

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