Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: filename in a cell

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Nate,

    one of the first things I usually do on a new sheet is add =cell("filename",a1) so I can find it later, just discipline, I guess. However, I often find myself deleting row 1 or column A a few times throughout the design which then gives an #N/A in this reference. Pain ? oh yes. Just a tip, but now whenever I use it, I use =cell("filename",aa9999).

    Just thought I'd share



  2. #12
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good point Chris, any cell reference on the sheet [without "sheetname"!] in question will "ground" any of the "filename" formulae in question. T'is why the a1 reference need not be an absolute value (i.e., $a$1)

    Cheers, Nate

    [ This Message was edited by: NateO on 2002-02-27 19:17 ]

  3. #13
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Another way (fyi):

    = LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1),LEN(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1))-4)


    Cheers, Nate

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •