+ Reply to Thread
Results 1 to 9 of 9

the meaning of formula ='.'!H19

  1. #1
    Registered User
    Join Date
    04-14-2011
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    6

    the meaning of formula ='.'!H19

    I found a formula as

    ='.'!H19

    what is that mean and how to create it?
    please help me
    thank you

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: the meaning of formula ='.'!H19

    You have a sheet named . (dot is name of the sheet)

    It returns value from cell H19 of the sheet .

    How to get that formula: In some cell of other sheet write = select sheet . select cell H19 and enter

  3. #3
    Registered User
    Join Date
    04-14-2011
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: the meaning of formula ='.'!H19

    thank you for quick reply

    unfortunately, there is no w/sheet with name '.', and no hidden w/sheet

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: the meaning of formula ='.'!H19

    Not '.'
    Just a .

  5. #5
    Registered User
    Join Date
    04-14-2011
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: the meaning of formula ='.'!H19

    yes,just a . (dot only), but none

    pls see the picture attach.
    sorry just print screen, the file a bit secret
    Attached Images Attached Images

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: the meaning of formula ='.'!H19

    I see there is some Macro involved so probably it hiding it.

  7. #7
    Registered User
    Join Date
    04-14-2011
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: the meaning of formula ='.'!H19

    wow, if u said so,,,,,,
    i give up, macro is locked & i have no password

    btw, nice share

  8. #8
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: the meaning of formula ='.'!H19

    Probably that is a point.

    macro create a sheet which you can not access which is used for some info or calculations.

    It's like quiz questions which would hide answers on that page. No use if you can look at it

  9. #9
    Registered User
    Join Date
    04-14-2011
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: the meaning of formula ='.'!H19

    hi mr zbor,

    could you please, give me a simply sample how to create it

    thank alot

+ Reply to Thread

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