Consulting

Results 1 to 3 of 3

Thread: linking problem..

  1. 11-27-2007, 11:50 AM #1
    JmE
    JmE is offline
    VBAX Regular
    Joined
    Jan 2007
    Posts
    8
    Location

    linking problem..

    i want to link to another sheet.. but i want to take the sheetname from a cell? like =B12!B18 :P

    =Blad1!B18
    Reply With Quote Reply With Quote
  2. 11-27-2007, 01:12 PM #2
    RichardSchollar
    RichardSchollar is offline
    VBAX Contributor
    Joined
    Aug 2006
    Location
    Hampshire, UK
    Posts
    140
    Location
    Hi

    You can do this using INDIRECT:

    =INDIRECT("'" & B12 & "'!B18")

    Richard
    Reply With Quote Reply With Quote
  3. 11-27-2007, 10:06 PM #3
    JmE
    JmE is offline
    VBAX Regular
    Joined
    Jan 2007
    Posts
    8
    Location
    Quote Originally Posted by RichardSchollar
    Hi

    You can do this using INDIRECT:

    =INDIRECT("'" & B12 & "'!B18")

    Richard


    thx (:
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules