+ Reply to Thread
Results 1 to 2 of 2

#ref!

  1. 12-08-2014, 09:11 PM #1
    mdt175
    mdt175 is offline
    Registered User
    Join Date
    09-30-2014
    Location
    Denver, CO
    MS-Off Ver
    2009
    Posts
    60

    #ref!

    I have attached a spreadsheet for help with a #REF! issue.

    I built a button on the "SNAPSHOT" tab which copies and pastes data so I can see how much was done that day which is depicted on the DEC 14 tab.

    I cannot figure out why B34-AF34 continue to go to #REF! when I run my macro.

    Can someone take a look and advise? I feel like it is a simple step I am missing.

    Thanks,
    Mitch
    Denver CO
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-08-2014, 10:56 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: #ref!

    What are the formulas before you run the macro?

    I don't see anything in your macros that updates either sheet 'Dec 14' or LW-2, the only obvious ways this could happen. I could try to reproduce it and track it down if you tell me what the "before" version of this sheet looks like.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1