Results 1 to 2 of 2

Thread: - Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jul:2010
    Location: Sofia
    Posts: 22

    - Excel

    . 10 000 , xlsx, , , . , . , replace- (. ch ), (. v ), ! add in , ??

  2. #2
    Registered User G@nius's Avatar
    Join Date: Feb:2010
    Location: Noob corner
    Posts: 137
    - . ( ).
    , . :

    Code:
    Sub Macro1()
    '
    ' Macro1 Macro
    '
    
    '
        Cells.Replace What:="ch", Replacement:="", LookAt:=xlPart, SearchOrder _
            :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
        Cells.Replace What:="a", Replacement:="", LookAt:=xlPart, SearchOrder _
            :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
        Cells.Replace What:="b", Replacement:="", LookAt:=xlPart, SearchOrder _
            :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
        Cells.Replace What:="v", Replacement:="", LookAt:=xlPart, SearchOrder _
            :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
    End Sub
    , () .

    , " ", " " " ". - .
    GIGABYTE 890GPA-UD3H | AMD Phenom II X4 925 2.8GHz / CM HYPER TX3 | 2 x 2GB SUPER TALENT DDR III 1333 CL9 | Sapphire HD5770 Vapor-X 1GB GDDR5 | WD 500GB SATA II Black | CM GX 650W | LG W2361V-PF, 23", 1920x1080 | Windows 7 Ultimate x64

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 |