+ Reply to Thread
Results 1 to 3 of 3

#REF! on First row

  1. 10-01-2009, 01:02 PM #1
    robert_mim
    robert_mim is offline
    Registered User
    Join Date
    09-30-2009
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    44

    #REF! on First row

    Hi,

    I have a macro and it is working except the First row with data A2 has the following data #REF!

    Please let me know what do you think is causing this error.

    Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 10-01-2009, 01:04 PM #2
    Marzuk
    Marzuk is offline
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Indianapolis, Indiana
    MS-Off Ver
    Office 2003 / Office 2007
    Posts
    114

    Re: #REF! on First row

    If you reference a cell then delete the cell that you are referencing, the formula that references the cell will show as #REF!. To avoid this, clear the contents of the cell but do not delete the cell itself.
    Reply With QuoteRegister To Reply
  3. 10-01-2009, 01:14 PM #3
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: #REF! on First row

    You can't expe ct an answer without posting your code.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    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