+ Reply to Thread
Results 1 to 1 of 1

Define Name problem using INDIRECT with ROW()

  1. #1
    Registered User
    Join Date
    03-10-2005
    Posts
    1

    Define Name problem using INDIRECT with ROW()

    Is there a reason why this simple Defined Name

    =INDIRECT("I"&ROW())="12/31/04"

    returns #VALUE! even though a Cell formula correctly returns TRUE (I6 = "12/31/04")?

    BTW, this Defined Name correctly resolves

    =INDIRECT("I6")="12/31/04"

    Why is a Defined Name failing on ROW() used with INDIRECT ?
    Last edited by pbassett; 03-10-2005 at 03:34 PM.

+ 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