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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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