+ Reply to Thread
Results 1 to 2 of 2

Cell Reference Returns #REF when data change

  1. #1
    Registered User
    Join Date
    03-25-2010
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    25

    Cell Reference Returns #REF when data change

    Good evening. I have been out of VBA for awhile and trying to update a golf league project built several years ago with some previous help from forum members. The project consists of 3 sheets where core data (scores, subs, and points) is maintained and 1 summary sheet. I used VBA code via a user form to capture and manipulate the core data. As the folks who have been maintaining the league are not Excel savvy, the project is completely locked and all input, updates, etc must be performed via the user form. In the past I had to make all updates to changes in players, etc. so have been working on a method to allow league management to update names, move players from the sub list to regular and other basic changes.

    The problem occurs when a player and associated data is moved from one sheet to another (Sub to Regular) in population on the Summary which is managed by normal Excel functions and references. The data moves correctly via the code between the core data sheets, but returns a #REF error on the Summary. This occurs with normal cell references and absolute ($) cell references. I do not believe this is a code issue, but am stumped and have included the code to move the data below:

    Please Login or Register  to view this content.
    Any advice on how to resolve will be appreciated.
    Last edited by Hawk; 05-01-2013 at 08:00 PM.

  2. #2
    Registered User
    Join Date
    03-25-2010
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Cell Reference Returns #REF when data change

    As usual, I discovered that the simplest solution can work. In this case I merely changed

    Please Login or Register  to view this content.
    to

    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)

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