Limiting a macro to a selection

macropod · #2 06-15-2012, 02:56 PM

It's all to do with the '.Wrap' property, which can Ask, Stop, or Continue.

As for the 'extra' lines, the macro recorder does generate quite verbose code. Your macro could at least be reduced to:

Code:

Sub ParasStripSelected()
With Selection.Find
  .ClearFormatting
  .Replacement.ClearFormatting
  .Text = "^p"
  .Replacement.Text = " "
  .Forward = True
  .Wrap = wdFindAsk
  .Format = False
  .MatchWildcards = False
  .Execute Replace:=wdReplaceAll
End With
End Sub

Further reductions are also possible, but you're not going to gain anything in processing speed and, depending on what the previous Find/Replace used as its parameters, you might need to clear/reset them anyway.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selection is locked	Thokkle	Word	1	04-01-2012 06:46 PM
How do you add to a selection list?	bryanarn	Excel	2	03-05-2012 05:04 PM
Macro to populate a text form field based on dropdown selection	koloa	Word	0	10-20-2011 11:52 AM
Limiting the times that it runs	hchbiker	PowerPoint	0	02-09-2011 08:36 AM
Save Selection	cksm4	Word VBA	25	01-30-2011 11:44 PM