Consulting

Results 1 to 2 of 2

Thread: macros

  1. 12-15-2011, 04:33 AM #1
    radha
    radha is offline
    VBAX Newbie
    Joined
    Dec 2011
    Posts
    1
    Location

    macros

    i need to remove alt-enter character from a work book which contains 7 work sheets


    thanks
    radha
    Reply With Quote Reply With Quote
  2. 12-15-2011, 05:19 AM #2
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    [VBA]For Each sht In ActiveWorkbook.Sheets
    sht.Cells.Replace What:=Chr(10), Replacement:=" ", LookAt:=xlPart, _
    SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
    ReplaceFormat:=False
    Next sht
    [/VBA]
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules