Scribd
Upload
44 views1 page

Code Word

This VBA macro removes any empty lines from the current selection by finding lines containing only a carriage return and replacing them with nothing, effectively deleting the empty lines.

Uploaded by

Austil Agboglodi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
44 views1 page

Code Word

This VBA macro removes any empty lines from the current selection by finding lines containing only a carriage return and replacing them with nothing, effectively deleting the empty lines.

Uploaded by

Austil Agboglodi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Sub Deleemptylines()

[Link]
[Link]
With [Link]
.Text = "^l"
.[Link] = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchByte = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = False
.MatchFuzzy = False
End With
[Link] Replace:=wdReplaceAll
End Sub

You might also like