![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
![]() This does seem slower than I would expect. You could try this version using ranges but it doesn't show a significant speed improvement. Code:
Sub Change_Value_to_Next_Cell_GOOD() Dim aRng As Range Dim sText As String sText = InputBox("Enter text to move cell") Set aRng = ActiveDocument.Range ActiveWindow.View = wdNormalView Application.ScreenUpdating = False With aRng.Find .ClearFormatting .Text = sText .Wrap = wdFindStop Do While .Execute If aRng.Information(wdWithInTable) Then aRng.Cells(1).Next.Range.FormattedText = aRng.FormattedText aRng.Delete aRng.MoveStart Unit:=wdCell, Count:=2 End If Loop End With Application.ScreenUpdating = True MsgBox " You're Selection is Done in the Active Document!" End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
![]() |
Tags |
find & replace, help please, speed |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
what method to find all cells paste linked to a certain cell ? | DBenz | Excel | 1 | 06-28-2018 12:16 PM |
Select Cell Text to paste into Find/Replace | CBarry | Word VBA | 2 | 02-16-2017 04:37 AM |
![]() |
amparete13 | PowerPoint | 3 | 03-11-2014 05:29 AM |
macro or find/replace | JamesVenhaus | Word | 2 | 02-27-2012 03:34 PM |
Find and Replace Macro - A Better Way | Tribos | Word VBA | 0 | 10-08-2008 03:22 AM |