|
|
#7
11-22-2013, 12:10 PM
|
|||
|
|||
Thank you Bob. I did wind up using a different code since the value in column A would be the same in all of the headers. I just used:
Sub DeleteRepeatedHeader() Dim LR As Long, i As Long LR = Range("A" & Rows.Count).End(xlUp).Row For i = LR To 2 Step -1 If Range("A" & i).Value = "PLANID" Then Rows(i).Delete Next i End Sub 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Mail Merge to create specific number of table rows
|
flackend | Mail Merge | 4 | 12-01-2023 02:49 PM |
|
Grouping table rows to prevent individual rows from breaking across pages
|
dennist77 | Word | 1 | 10-29-2013 11:39 PM |
| Print attachment when it arrive in specific folder with specific subject | visha_1984 | Outlook | 1 | 01-30-2013 10:42 AM |
|
Count rows and add blank rows accordingly
|
Hoochtheseal | Word VBA | 1 | 01-29-2013 09:23 PM |
| Adding columns in specific rows only | mhays | Excel | 5 | 01-17-2012 09:13 AM |
Windows XP 
Office 2010 32bit
Threaded Mode