i need to remove alt-enter character from a work book which contains 7 work sheets
thanks
radha
i need to remove alt-enter character from a work book which contains 7 work sheets
thanks
radha
[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.