Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 01-30-2024, 09:15 AM
gmaxey gmaxey is offline select until = Windows 10 select until = Office 2019
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

vivka,


Wouldn't this work just as well and avoid the selection?


Code:
Sub Test_Macro()
'Copy a range from the current para's start till after "=" and 'paste it after the para.
Dim oRng As Range
  Set oRng = Selection.Paragraphs(1).Range
  Selection.Find.ClearFormatting
  Selection.Find.Replacement.ClearFormatting
  With oRng.Find
    .Text = "="
    .Forward = True
    .Wrap = wdFindStop
    .Format = False
    If .Execute Then
      oRng.InsertAfter vbCr
      oRng.Paragraphs(1).Next.Range.FormattedText = oRng.Paragraphs(1).Range.FormattedText
    End If
  End With
lbl_Exit:
  Exit Sub
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
select until = Select until last row Marcia Excel Programming 4 08-12-2022 03:54 PM
Select entire text and then de-select certain Headings? tq94 Word 3 02-26-2022 03:47 AM
Select text between 2 yacov Word VBA 2 08-15-2021 10:16 PM
select until = Select a row in a different tab cosmicyes Excel Programming 1 07-09-2018 02:47 AM
select until = How to select row aymanharake Excel Programming 3 02-18-2017 04:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft