+ Reply to Thread
Results 1 to 3 of 3

Error " Run-time error '1004': application defined or object defined error

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    Kentucky, United States
    MS-Off Ver
    03,07,10
    Posts
    61

    Exclamation Error " Run-time error '1004': application defined or object defined error

    Hello,

    I am trying to sum the value of cells in column P on Click through command button. I have created the command button but the kicker is the values within the column could be A-Z. I need the value to be listed out in totals below the EOF line. The Macro will end the sum at EOF in Column A.

    Column P Column A
    09/04/13 E
    09/04/13 F
    09/04/13 E
    09/03/13 D
    09/04/13 E
    EOF

    The letters at the end of the date are to be counted.

    Descending in Cells however IF there is no A or B or R or S then these cells need to be absent. The good thing is they will always be in order (i.e. if there is an I and a C then you will have A-I that will exist as data but it is always changing.

    D = 1
    E = 3
    F = 1


    To Total all rows (which may have new rows added so it is to end at EOF in Column A) I do not have enough code worked up on this to give an example yet but once I have enough written I will submit. If you have and suggestions in the mean time please share.

    Please Login or Register  to view this content.
    Thank you,
    Leslye
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Error " Run-time error '1004': application defined or object defined error

    In ActiveCell.Value = Application.Sum(Range(Cells(e, 2), Cells(e, C))), where is e initialized?

    With the code as written, e = 0 ====> There is no such thing as row 0.

    Also, the workbook posted has no macros.
    Last edited by protonLeah; 09-11-2013 at 12:01 AM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-14-2013
    Location
    Kentucky, United States
    MS-Off Ver
    03,07,10
    Posts
    61

    Re: Error " Run-time error '1004': application defined or object defined error

    I was able to figure our the coding on my own. Please see below attached to an Activex_ Commandbutton1:

    Please Login or Register  to view this content.

+ 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: 1
    Last Post: 05-06-2013, 06:07 AM
  2. [SOLVED] Macro causes Run time error 1004 Application defined or object-defined error
    By Firefighter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2012, 04:09 AM
  3. [SOLVED] run-time error '1004' application-defined or object-defined error - Excel 2007
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2012, 02:46 AM
  4. Macro - Run-time Error '1004': Application defined or object defined error
    By robby10 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-14-2010, 07:55 AM
  5. [SOLVED] Run-time Error 1004: Application-defined or Object-defined Error
    By Adrian in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-23-2005, 02:05 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