Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-29-2020, 07:10 AM
alex100 alex100 is offline Multiple conditional operators with Find/Execute & move cursor at the end of a range Windows 7 64bit Multiple conditional operators with Find/Execute & move cursor at the end of a range Office 2016
Advanced Beginner
Multiple conditional operators with Find/Execute & move cursor at the end of a range
 
Join Date: May 2020
Posts: 79
alex100 is on a distinguished road
Default Multiple conditional operators with Find/Execute & move cursor at the end of a range

I have two questions, please...

1) I'm using the code below to change all fonts that have a size of 10. How can I adapt it so that it can also include font sizes smaller than 10? I tried setting the size condition to '.Font.Size <= 10' but all I received was an error.



Code:
Dim MyRange As range
Set MyRange = Selection.range
With MyRange.Find
    .Font.Size = 10
    .Forward = False
    .Replacement.Font.Size = 12
    .Replacement.Font.Name = "Arial"
    .Execute Replace:=wdReplaceAll
   End With
2) Using the following code for pasting, how can I move the cursor at the end of the range? As it is now, it only moves it at the end of the first paragraph.

Code:
Dim pasted_content As range
Set pasted_content = Selection.range
pasted_content.Paste
With pasted_content
    Selection.MoveEnd Unit:=wdParagraph, Count:=1
End With
Thank you!

Alex

Last edited by alex100; 05-29-2020 at 12:44 PM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple conditional operators with Find/Execute &amp; move cursor at the end of a range One line find execute in this case is possible? eduzs Word VBA 1 05-18-2020 10:52 AM
Execute a Sub OR routine or macro based on multiple user choices from a dropbox VitorH Word VBA 1 03-29-2019 02:48 AM
Multiple conditional operators with Find/Execute &amp; move cursor at the end of a range How to avoid find.execute moving focus and restore exact view after search diracsbracket Word VBA 3 10-30-2016 03:17 AM
Find Bookmark, move to bookmark, execute code, repeat raymm3852 Word VBA 10 04-15-2016 06:21 PM
Multiple conditional operators with Find/Execute &amp; move cursor at the end of a range Find and Execute cksm4 Word VBA 1 10-22-2011 11:36 PM

Other Forums: Access Forums

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