Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Assigning the value in a named range to a shape (Excel)

    Does anyone know if you can place the value of a named range into a shape (instead of just typing a static value in).

    Thx,
    otk

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Assigning the value in a named range to a shape (Excel)

    Click on the shape
    in the formula bar enter an equal (=) and then enter the name of the range (or the cell reference) or just click on the cell that you want to link.

    Steve

  3. #3
    Lounger
    Join Date
    Oct 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Assigning the value in a named range to a shape (Excel)

    Thanks, I found that shortly after posting this.

Posting Permissions

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