+ Reply to Thread
Results 1 to 5 of 5

Formula References Other Sheet But Errors

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,767

    Formula References Other Sheet But Errors

    .
    .
    VBA macro that creates a formula is creating an error : # NAME

    Here is the macro :

    Please Login or Register  to view this content.

    And this is the formula created by the macro. Note that the sheet names will have empty spaces. Removing the empty spaces is not an option.

    B4 is the error ... B6 is the formula created and inserted into B4.

    Note the single quotation marks inserted in the formula ----- they should not be there. How do I get rid of them ?


    Error.jpg
    Last edited by Logit; 07-07-2020 at 03:29 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,472

    Re: Formula References Other Sheet But Errors

    You need to use
    Please Login or Register  to view this content.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,767

    Re: Formula References Other Sheet But Errors

    .
    Fluff thanks for responding.

    Still receiving an error : # REF!

    Here is the formula created : ='Project 2'!G7

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,767

    Re: Formula References Other Sheet But Errors

    .
    Fluff

    Disregard ... my error. It has been corrected and works now. Thanks a bunch !!

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,472

    Re: Formula References Other Sheet But Errors

    You're welcome & thanks for the feedback.

+ 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. Replace sheet in workbook with new sheet without #REF formula errors
    By ExcelNewbie2020 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-12-2020, 11:23 PM
  2. Nested Relative references in VBA - Errors for what should be easy
    By mangoose736 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2016, 02:26 PM
  3. [SOLVED] #REF! Errors after copying formula to new sheet
    By Big.Moe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-30-2013, 11:11 PM
  4. Copying sheet with relative formula named range causes errors.
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-19-2011, 08:44 AM
  5. Replies: 1
    Last Post: 03-01-2011, 03:31 PM
  6. Repetitive sheet references in formula
    By eugbed in forum Excel General
    Replies: 3
    Last Post: 05-01-2010, 12:33 AM
  7. Copy Formula That References Another Sheet
    By JR573PUTT in forum Excel General
    Replies: 9
    Last Post: 02-16-2006, 06:24 PM

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