![]() |
#1
|
|||
|
|||
![]()
Hi,
I have found this macro which is working, but not entirely as I want. I need that macro go through every table in document - now it only works in one table. Public Sub DeleteEmptyColums() Dim Table As Table, Row As Range, Cell As Cell, Counter As Long, _ NumRows As Long, TextInRow As Boolean ' Specify which table you want to work on. Set Table = Selection.Tables(1) ' Set a range variable to the first row's range Set Row = Table.Rows(1).Range NumRows = Table.Rows.Count ' Next Table Application.ScreenUpdating = False For Counter = 1 To NumRows StatusBar = "Row " & Counter TextInRow = False With Selection.Tables(1) For i = .Rows.Count To 1 Step -1 If Len(.Cell(i, 2).Range.Text) = 2 Then .Rows(i).Delete End If Next i End With Next Counter Application.ScreenUpdating = True End Sub Any ideas? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
sjeff | Excel | 2 | 10-22-2013 11:21 PM |
![]() |
Mr Davo | Excel | 1 | 10-29-2012 01:07 AM |
Can I change the horizontal scrollbar to scroll smoothly rather than column by column | carpat | Excel | 0 | 01-10-2012 09:34 AM |
How can I delete the content of a cell in column if the cell value is more than 1000? | Learner7 | Excel | 2 | 06-27-2011 05:44 AM |
delete email message via blackberry and have it delete on my pop3 and my outlook | Iamthestorm | Outlook | 2 | 10-28-2010 12:21 AM |