Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 10-31-2022, 03:48 PM
Guessed's Avatar
Guessed Guessed is offline Help with debugging a simple macro to cut and paste selected text to end of document Windows 10 Help with debugging a simple macro to cut and paste selected text to end of document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Try this version of the macro - it doesn't require the secondary macros.
Code:
Sub MoveBlockToBeginningOfSentence()
  Dim aRngMove As Range, aRngStart As Range
  Set aRngMove = Selection.Range
  If aRngMove.Characters.Last <> " " Then 'ensure the selection includes a space at the end
    aRngMove.MoveEndUntil cset:=" "
    aRngMove.MoveEnd Unit:=wdCharacter, Count:=1
  End If
  Set aRngStart = aRngMove.Sentences(1)
  aRngStart.Characters(1).Case = wdLowerCase
  aRngStart.Collapse Direction:=wdCollapseStart
  aRngMove.Characters(1).Case = wdTitleWord
  aRngStart.FormattedText = aRngMove.FormattedText
  aRngMove.Delete
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with debugging a simple macro to cut and paste selected text to end of document Keep text selected after paste dabbler Word 14 01-11-2021 09:54 AM
Help with debugging a simple macro to cut and paste selected text to end of document Copy selected text from one document and paste to new document in same position on the page gasparik Word VBA 1 05-11-2020 05:41 AM
Help with debugging a simple macro to cut and paste selected text to end of document Find and Replace Selected Text or Macro for finding selected text mrplastic Word VBA 4 12-20-2019 01:25 PM
Help with debugging a simple macro to cut and paste selected text to end of document Help debugging a Macro that merges individual word docs into one document vincenzo345 Word VBA 4 12-01-2017 11:25 AM
Help with debugging a simple macro to cut and paste selected text to end of document Macro (debugging) JACKsparrow Word VBA 1 03-09-2016 02:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:08 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