radha
12-15-2011, 04:33 AM
i need to remove alt-enter character from a work book which contains 7 work sheets
thanks
radha
p45cal
12-15-2011, 05:19 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.