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

Thread: worksheet name in cell

  1. #11
    Board Regular
    Join Date
    Aug 2012
    Location
    Auckland, NZ
    Posts
    1,511
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: worksheet name in cell

    Hi Aladdin,

    Just got directed to this from another post. I've never come across the get.workbook structure before - where is it documented? Also, it seems strange that the function works when used to define a name, but doesnt work when put into a worksheet cell.

    Grateful if you could enlighten me.

    Many thanks
    Peter

    Excel 2010, Windows 7
    Accuracy in posting formula's to the forum will help enormously, clairvoyancy is a skill I've yet to develop!!

  2. #12
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,593
    Post Thanks / Like
    Mentioned
    31 Post(s)
    Tagged
    6 Thread(s)

    Default Re: worksheet name in cell

    Quote Originally Posted by pjmorris View Post
    Hi Aladdin,

    Just got directed to this from another post. I've never come across the get.workbook structure before - where is it documented? Also, it seems strange that the function works when used to define a name, but doesnt work when put into a worksheet cell.

    Grateful if you could enlighten me.

    Many thanks
    There is more on such macros on this very site. For more, see: http://www.ashishmathur.com/tag/xlm-4-0-macro/
    Assuming too much and qualifying too much are two faces of the same problem.

  3. #13
    Board Regular
    Join Date
    Aug 2012
    Location
    Auckland, NZ
    Posts
    1,511
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: worksheet name in cell

    Many thanks for this - interesting that a macro can feature in a Name definition, I'd never come across that before.

    Regards
    Peter

    Excel 2010, Windows 7
    Accuracy in posting formula's to the forum will help enormously, clairvoyancy is a skill I've yet to develop!!

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
  •