Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 02-09-2014, 01:49 PM
mrayncrental mrayncrental is offline Cut Text from one table cell to another Windows 7 64bit Cut Text from one table cell to another Office 2007
Novice
Cut Text from one table cell to another
 
Join Date: Feb 2014
Posts: 15
mrayncrental is on a distinguished road
Talking Solved

This worked perfectly and is more efficient. Added 2 minor tweaks:

- Some of my cells have more than one set of [] words, so I subtracted the row number to research the cell again if first set is found

- Added additional row return

Code:
Sub 1()
'
' Macro to take any [] words from column 3 and move to column 2,
' then search and replace to remove the brackets
'

    Dim rng As Range, rng2 As Range, sText As String
    Dim aTbl As Table, iRow As Integer, aCell As Cell
    
    Set aTbl = ActiveDocument.Tables(1)
    Set rng = aTbl.Range
    
    For iRow = 1 To aTbl.Rows.Count
      Set rng = aTbl.Cell(iRow, 3).Range
      
      With rng.Find
        .ClearFormatting
        .Text = "\[*\]"
        .MatchWildcards = True
        
        If .Execute = True Then
          sText = Replace(rng.Text, "[", "")
          sText = Replace(sText, "]", "")
          Set rng2 = aTbl.Cell(iRow, 2).Range
          
          If Len(rng2.Text) > 2 Then
            rng2.MoveEnd Unit:=wdCharacter, Count:=-1
            rng2.Collapse Direction:=wdCollapseEnd
            rng2.Text = vbCr & vbCr & sText
          Else
            rng2.Text = sText
          End If
          
          rng.Delete

' Don't advance cell unless no brackets found
          
          iRow = iRow - 1
        
        End If
      End With
    Next iRow

End Sub
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cut Text from one table cell to another Can I create a single-cell table that moves with the text? lcaretto Word Tables 7 11-01-2013 06:04 AM
Enter text into next available cell in a table molesy Word VBA 2 09-11-2013 02:25 AM
Cut Text from one table cell to another Text Form Fields - Filling the table cell simville02 Word Tables 1 01-31-2013 11:12 PM
Text Wrapping on Fixed Lines in a Form field/Table cell okrmjr Word Tables 0 10-30-2009 08:52 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

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