I want Marco solution to remove specific Raw having only .(dot Character)

PRA007 · #1 12-02-2014, 11:19 PM

Hello Every one.
I am struggling to figure it out how to do this
My table is in this format

http://3.bp.blogspot.com/-l3WXGukdIk...Zo/s1600/1.jpg

I want to remove the row having only dot in first cell followed by empty cell

gmayor · #2 12-03-2014, 03:58 AM

If by 'dot' you mean a period 'chr(46)' then

Code:

Dim oRow As Row
    For Each oRow In ActiveDocument.Tables(1).Rows
        If oRow.Cells(1).Range.Characters(1) = Chr(46) And _
           Len(oRow.Cells(1).Range) = 3 And _
           Len(oRow.Cells(2).Range) = 2 Then
            oRow.Delete
        End If
    Next oRow

PRA007 · #3 12-04-2014, 01:53 AM

Thank You very much. It deed job for me. This was my first post.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to remove "\|" character in Word	davidplowman	Word	1	06-23-2014 11:39 AM
How do I output special character to a specific cell (x,y)?	norwood	Word VBA	2	01-31-2014 01:26 PM
Remove first character from text file	dwillyfan	Word VBA	1	09-04-2012 08:29 PM
Need VBA For Macro On How To Remove Specific Words	netchie	Word VBA	6	08-28-2012 03:37 PM
Remove specific recipients while replying to all	McFerra	Outlook	0	12-22-2010 10:13 PM