![]() |
|
|
Thread Tools | Display Modes |
#2
|
|||
|
|||
![]()
By "dots" do you mean blank space or do you mean periods "."?
If the former then try: HTML Code:
Sub ScratchMacro() 'A basic Word macro coded by Greg Maxey Dim oRow As Word.Row For Each oRow In Selection.Tables(1).Rows Do While oRow.Cells(1).Range.Characters.First = Chr(32) oRow.Cells(1).Range.Characters.First.Delete Loop Do While oRow.Cells(2).Range.Characters.First = Chr(32) oRow.Cells(2).Range.Characters.First.Delete Loop If Len(oRow.Range) = 6 Then oRow.Delete End If Next End Sub |
Tags |
delete, macro, table |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only | mag | Excel | 0 | 10-28-2012 08:04 PM |
How to "hard link" two adjacent cells to a data validation drop down list? | Geza59 | Excel | 10 | 10-19-2012 11:56 AM |
'Linking' entered information to other "cells" from an original "cell" in MS Word | Wade | Word | 6 | 09-03-2012 05:22 PM |
![]() |
ubns | Excel Programming | 2 | 08-14-2012 02:01 AM |
Automated "Macro" to delete Tags/Anchors | field3 | Word VBA | 0 | 02-25-2009 02:53 PM |