Results 1 to 22 of 22

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jul:2009
    Location:
    Posts: 10

    Excel

    ,
    , VBA, , .. worksheet. , , .
    VBA worksheet - , ? - - worksheet-a - ?

    (-)

  2. #2
    Registered User mermaid's Avatar
    Join Date: Aug:2005
    Location:
    Posts: 850
    Quote Originally Posted by amurder View Post
    ,
    , VBA, , .. worksheet. , , .
    VBA worksheet - , ? - - worksheet-a - ?

    (-)

    , .
    , ...
    , ...
    , ?!?

  3. #3
    Banned
    Join Date: Jun:2008
    Location:
    Posts: 1,880
    ........
    ""

  4. #4
    Creative destructor OgiDogi's Avatar
    Join Date: Nov:2002
    Location:
    Posts: 7,601
    Quote Originally Posted by amurder View Post
    ,
    , VBA, , .. worksheet. , , .
    VBA worksheet - , ? - - worksheet-a - ?

    (-)
    , , .

  5. #5
    Registered User
    Join Date: Jul:2009
    Location:
    Posts: 10
    @mermaid : .
    sheet
    , (, ) - 3 sheets VBA .
    sheet "EGN" "EGN_Prov" "EGN_Date" VBA .
    Sheet1 B2 Excel .
    sheet "ENG" - , . .
    Sheet1 , B2 EGN_Prov() sheet "EGN", , Proverka(A1) .

    @OgiDogi : , , . sheet -, :
    =IF(LEN(A1)=10;(IF((MOD(MOD(INT(MID(A1;1 ;1))*2+INT(MID(A1;2;1))*4+INT(MID(A1;3;1 ))*8+INT(MID(A1;4;1))*5+INT(MID(A1;5;1)) *10+INT(MID(A1;6;1))*9+INT(MID(A1;7;1))* 7+INT(MID(A1;8;1))*3+INT(MID(A1;9;1))*6; 11);10)=INT(MID(A1;10;1)));" ";" "));" 10 ")
    ? :
    -, Proverka(A1), .
    , , , .. 20 1 12, 19 21 32, 21 41 52, 29- , 30 31 , 01.04.1916 13.04.1916 .. , , sheet , .

    .. - -


    copyright: entium :
    http://hardwarebg.com/forum/showpost...97&postcount=2
    Attached Files
    Last edited by amurder; 17th July 2009 at 08:59. Reason:

  6. #6

    Join Date: Jun:2002
    Location: 85435
    Posts: 4,619
    VB . .
    X570 Aorus Elite || R5 3600x || NH-D14 || 32GB RAM || GTX1070Ti Ultra Silent || PCE-AC56 || 850 EVO+MP510+HDDs || SSR-650RT all in Dark Base 900 || EV2736W || G29 || Obutto Ozone+Sparco R333

  7. #7
    Registered User
    Join Date: Jul:2009
    Location:
    Posts: 10
    VBA?

  8. #8
    Banned
    Join Date: Jun:2008
    Location:
    Posts: 1,880
    Quote Originally Posted by amurder View Post
    VBA?
    Create a name to represent a formula or a constant

    On the Insert menu, point to Name, and then click Define.
    In the Names in workbook box, enter the name for the formula.
    In the Refers to box, type = (equal sign), followed by the formula or the constant (constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.) value.
    ...

  9. #9
    Registered User
    Join Date: Jul:2009
    Location:
    Posts: 10
    1, .
    .
    - -
    =IF(LEN(A1)=10;IF(F19;" ";" ");" 10 ") - - , .

  10. #10
    Banned
    Join Date: Jun:2008
    Location:
    Posts: 1,880
    Quote Originally Posted by amurder View Post
    1, .

  11. #11
    Registered User
    Join Date: Jul:2009
    Location:
    Posts: 10
    Quote Originally Posted by ven_stoich View Post
    ?
    "Refers to" , .

    ---------- 16:32 ---------- 16:28 ----------

    Quote Originally Posted by ven_stoich View Post
    ?
    - - .
    - -.
    Macro Security-.

  12. #12
    Banned
    Join Date: Jun:2008
    Location:
    Posts: 1,880
    Quote Originally Posted by amurder View Post
    ?
    "Refers to" , .

    ---------- 16:32 ---------- 16:28 ----------



    - - .
    - -.
    Macro Security-.
    , ...

  13. #13
    bullet pavelp's Avatar
    Join Date: Jul:2004
    Location: Sofia
    Posts: 7,420
    Quote Originally Posted by amurder View Post
    1, .
    .
    "$" , .
    ? .

    ,
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	shot.jpg‎ 
Views:	1329 
Size:	28.6 KB 
ID:	22536  

  14. #14
    Registered User
    Join Date: Jul:2009
    Location:
    Posts: 10
    "-" ...

    17:30 - online 27-. 27-.

  15. #15
    Banned
    Join Date: Jun:2008
    Location:
    Posts: 1,880
    ?

  16. #16
    Registered User
    Join Date: Jul:2009
    Location:
    Posts: 10
    @pavelp
    , sheet-

  17. #17
    bullet pavelp's Avatar
    Join Date: Jul:2004
    Location: Sofia
    Posts: 7,420
    Quote Originally Posted by amurder View Post
    @pavelp
    , sheet-
    scope-. "workbook". sheet.
    (edit: . sheet "sheet1!" , -" )


    ?
    - " - 0, 1, , 2"

  18. #18
    Registered User
    Join Date: Jul:2009
    Location:
    Posts: 10
    ,
    . online 27.07.2009 . , , .

  19. #19
    bullet pavelp's Avatar
    Join Date: Jul:2004
    Location: Sofia
    Posts: 7,420
    "- "

  20. #20
    Registered User
    Join Date: Aug:2009
    Location: Asenovgrad
    Posts: 1
    W, Amurder,
    , . , Excel VBA, . , , , ...

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |