![]() |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
|
|||
|
|||
|
So your table has 10 columns odd have numbers with "$" and even are empty. Yes? Try: Code:
Sub Macro1()
Dim lngIndex As Integer
Dim oTbl As Table
Dim oRng As Range
Dim strText As String
Dim lngCol As Long
Dim varVal
strText = InputBox("Enter text to move cell")
Application.ScreenUpdating = False
For Each oTbl In ActiveDocument.Tables
For lngCol = 1 To oTbl.Columns.Count - 1 Step 2
For lngIndex = 1 To oTbl.Rows.Count
Set oRng = oTbl.Cell(lngIndex, lngCol).Range
oRng.End = oRng.End - 1
varVal = Split(oRng.Text, strText)
If UBound(varVal) = 1 Then
oRng.Text = Trim(varVal(1))
oRng.Cells(1).Next.Range.Text = strText
End If
Next lngIndex
DoEvents
Next lngCol
Next oTbl
Application.ScreenUpdating = True
MsgBox "Tables processed"
lbl_Exit:
Set oTbl = Nothing
Set oRng = Nothing
Exit Sub
End Sub
|
|
#2
|
||||
|
||||
|
OMG, You did it. Wow, wow, wow, you are a genius.
I've been trying for months, analyzing, trying, and I didn't come close to your result. Thank you soooooo very much. Most of our French documents are like that, if they have $ and %, we usually need to put them in a separate columns to have all the numbers aligned perfectly. And unlike in English, where the $ are in front of the numbers, our $ are in the back. So we put both the % and $ in the same columns and all the numbers can be aligned. What a fantastic group of people here. I'm truly grateful ![]() Have a super duper reste of the week
|
|
| Tags |
| find & replace, help please, speed |
|
|
Similar Threads
|
||||
| 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 |
Find and Replace Macro
|
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 |