Results 1 to 14 of 14

Hyperlink problem if space in Sheet Name

Threaded View

  1. #1
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Smile Hyperlink problem if space in Sheet Name

    I've a problem using hyper link when I've a space between sheet name…… Please guide me in this regard.

    =HYPERLINK(CELL("address",INDIRECT(A5&B5&"!C3")))
    Where A5 is First Sheet Name "Jan" and B5 is second part of sheet name "Expense".

    It works properly but when i've space in sheet name then unable to work. I've used below format but still no luck

    =HYPERLINK(CELL("address",INDIRECT("'"&A4&" "&B4&"'"&"!C3"))

    Also, If I have space in file name than its also not working.

    Please give the solution in both cases of Space in File name & space in sheet name in my attached file.

    Thanks in advance
    Attached Files Attached Files
    Last edited by mubashir aziz; 05-14-2009 at 07:02 AM. Reason: Solved
    If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.

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