How Trim work in Excel VBA

[shabar]

I have got following code for get rid of middle spaces, line feed and Trim
But Trim doesn't work What could be the reason
Hi All




I have got following code for get rid of middle spaces, line feed and Trim


But Trim doesn't work What could be the reason


Sub Replace()




With Sheets("Input_Data").Range("A1:A6300")
'With Sheets("Input_Limits").Range("A1:A6300")

.Cells.Replace " ", " ", xlPart, xlByRows, False
.Cells.Replace vbLf, "", xlPart, xlByRows, False
'.Cells.Trim


End With

End Sub







It gives Error- Object doesn't support this property method
Cheers
Shabar

[June7]

Google: Excel trim

http://office.microsoft.com/en-us/ex...003056131.aspx