Your code works fine for me.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"mtsark" wrote in message
...
I am trying to trim the leading spaces from all text in Column
U.
I have have the following code but when I run it nothing
happens (the
leading spaces are still there). I've tried both LTRIM and
TRIM but neither
seems to work.
What am I missing?

Dim Rng as Range
Sheets("Raw Projections").Select
For Each Rng In ActiveSheet.Range("U6:U500")
Rng.Value = LTrim(Rng.Value)
Next Rng

Matt