Thread
:
macro to delete spaces doesn't compile
View Single Post
#
1
Posted to microsoft.public.excel.programming
Janis
external usenet poster
Posts: 360
macro to delete spaces doesn't compile
This macro has an error and doesn't compile. I also need it to delete 2
spaces.
Sub delSpaces()
Intersect(Selection, Selection.SpecialCells(xlConstants,
xlTextValues)).replace(", ",",")
End Sub
tia,
Reply With Quote
Janis
View Public Profile
Find all posts by Janis