+ Reply to Thread
Results 1 to 2 of 2

Cell reference error in macro?

  1. #1
    Registered User
    Join Date
    05-11-2018
    Location
    davis, ca
    MS-Off Ver
    office 365
    Posts
    14

    Cell reference error in macro?

    I am trying to record a simple macro to make a line chart showing date (x-axis) and data value (y-axis). I want to use the same macro in many worksheets. The work sheet formats are identical. I assume I should be specifying relative cell references in the macro because I want to use the macro in different worksheets from the worksheet in which it was created. However, when I run the macro in a worksheet different from the worksheet in which it was recorded I get an error that I cannot decipher:

    'Run time error 1004
    Application defined or object defined error'

    The help screen is Greek to me. I don't know VB. Any ideas?
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Cell reference error in macro?

    To diagnose a code error we have to see the code. The file you attached is not macro-enabled so has no code. You must save a file with macros as a .xlsm file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Error on cell reference
    By fzoull in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2016, 03:02 PM
  2. [SOLVED] Cell reference error in VBA
    By bennyamy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2016, 09:35 AM
  3. [SOLVED] Cell Reference returns error
    By wiwchar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-23-2015, 05:28 PM
  4. Help: #VALUE! error using function macro to reference other network closed spreadsheets
    By Johnny Lawndart in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2014, 01:03 PM
  5. Reference Error Macro VBA
    By britzer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2013, 12:27 PM
  6. Replies: 1
    Last Post: 04-30-2012, 12:07 PM
  7. Correct reference error on cell
    By avidcat in forum Excel General
    Replies: 8
    Last Post: 12-31-2009, 05:43 AM

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