Results 1 to 7 of 7

Thread: VBA Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Oct:2007
    Location: de
    Posts: 2

    VBA Excel

    ,

    . , . . . ( / ).

    - 3 default , excel ",1,2" "januar,februar,maerz"

    VBA :

    Sheets("1").Name = "februar"

    1.( ) - , "". -

    2. - VBA "1". - subscript out of range. "1" - .

    , default sheets . , , -a.( ).

    , "1" ., . .

    , .

  2. #2
    Registered User leechaa's Avatar
    Join Date: Aug:2007
    Location:
    Posts: 27

    Exclamation

    , .

    Code:
    Sub testsheet()
    Sheets(1).Name = " "
    End Sub
    Last edited by leechaa; 15th October 2007 at 14:38.
    , .

  3. #3
    's Avatar
    Join Date: Mar:2005
    Location:
    Posts: 379
    :

    nam="februar"
    Sheets("1").Name = "februar"
    worksheets(nam).Activate ..

    worksheets , , .
    , , , ,

  4. #4
    Registered User
    Join Date: Oct:2007
    Location: de
    Posts: 2
    Quote Originally Posted by View Post


    Sheets("1").
    1 , .

    ,
    , , . ("") Tabelle , . , .

    .

    , . , , .

    leechaa - , .

  5. #5
    Registered User leechaa's Avatar
    Join Date: Aug:2007
    Location:
    Posts: 27
    , :P
    , .

  6. #6
    Registered User leechaa's Avatar
    Join Date: Aug:2007
    Location:
    Posts: 27
    , .
    Microsoft Office XP Professional .
    , advanced code page conversion tables, : 21025 (IBM EBCDIC - Cyrillic (Serbian, Bulgarian))
    !
    , .

  7. #7
    's Avatar
    Join Date: Mar:2005
    Location:
    Posts: 379
    , .
    , , . , .

    , , , ?
    , , , ,

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 |