Results 1 to 10 of 10

_xlfn.IFERROR Named Range?

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    _xlfn.IFERROR Named Range?

    I'm trying to learn what is causing for 2 named ranges to show up in essentially a blank workbook. By blank, in trying to learn/isolate what is causing this issues, I deleted every worksheet out of the file and resaved it under a new name.

    From what I can remember, the original file was made in Excel 2013 and it was also resaved as a 2013 file. The file is an 'xlsm' file as it did originally have a bunch of macros, but i stripped it all down to just the one macro to list out the named ranges.

    So a blank file that is giving to strange named ranges?

    EDIT. I just found another topic on this issue here. That attached sample probably/may not show any error it appears it may have 'disappeared' when you save close and reopen

    http://stackoverflow.com/questions/1...-does-not-work

    Now if I only I can find what is causing that in my original, bigger file.
    Attached Files Attached Files
    Last edited by ptmuldoon; 03-16-2016 at 08:46 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Compare cells to named range and create new sheets using related named range
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-10-2015, 03:35 PM
  2. [SOLVED] Assign named range to one cell depending on named range in another
    By x65140 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2015, 11:04 AM
  3. [SOLVED] determining if cell is part of named range and what that named range is
    By stnkynts in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2014, 07:56 PM
  4. Replies: 1
    Last Post: 02-27-2013, 12:00 AM
  5. _xlfn.AVERAGEIFS convert to 2003
    By ChrisRoc22 in forum Excel General
    Replies: 1
    Last Post: 10-05-2012, 07:30 AM
  6. [SOLVED] Determine what Named Range the Target Address is and return Named Range Name
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2012, 10:49 PM
  7. _xlfn.AVERAGEIF ... How do I remove this?
    By John Bates in forum Excel General
    Replies: 2
    Last Post: 08-21-2008, 10:42 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