Thread
:
Trim the entire range
View Single Post
#
1
Posted to microsoft.public.excel.programming
Greg
external usenet poster
Posts: 331
Trim the entire range
Hi,
I have the following code that loops through a certain range.
For Each cel In ADINames
cel.Value = Trim(cel.Value)
Next cel
Can this be done on the entire range at once, i.e, w/o looping?
Thank you,
--
______
Regards,
Greg
Reply With Quote
Greg
View Public Profile
Find all posts by Greg