Help required with spacing

rohanmalhotra · #1 08-10-2011, 05:46 AM

Hi

I have created a macro that automatically gives 2 spaces after a period. Unfortunately, it also gives 2 spaces in a URL. Not sure how to rectify this. I have attached the code below :

HTML Code:

Sub TwoSpaces()
    Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
    With Selection.Find
        .Text = "([.])"
        .Replacement.Text = "\1  "
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchWildcards = True
    End With
    Selection.Find.Execute Replace:=wdReplaceAll
End Sub

Any help will be appreciated.

Thanks in advance.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Suggestion required	domex	Word	0	10-06-2010 05:35 AM
Filename Extensions required in VBA	bollivar_corona	Word	0	08-06-2010 10:15 AM
Filename Extensions required in VBA	bollivar_corona	Word VBA	0	08-04-2010 10:33 PM
Basic help with word required !!	bobbybansal	Word	1	04-20-2010 02:31 PM
Urgent Help Required	id12345	Word	4	12-29-2009 08:22 AM