Bernd Plumhoff

Posts: n/a

You are welcome.

If only one specific header has to be ignored, change:
....
If Cells(i - 1, 1).Value < Cells(i, 1).Value Then
....
to

If (Cells(i - 1, 1).Value < Cells(i, 1).Value) and _
Left(Cells(i, 1).text,20)< "First 20 Chars of Header Row" Then

for example (if you have to cross that bridge again).

HTH,
Bernd

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
macro to browse for workbook, pick up data and looping	uriel78	Excel Worksheet Functions	1	March 10th 05 12:37 PM
Activate a macro to insert a row and copy the formuals from the rows above to the blank row	oil_driller	Excel Discussion (Misc queries)	1	February 11th 05 03:30 PM
Looping Macro to Find and Mark	Big Tony	New Users to Excel	8	January 26th 05 09:07 PM
Inserting Blank Rows Macro?	Michael Saffer	Excel Worksheet Functions	2	November 9th 04 06:23 PM
macro to not print blank value rows in invoice	Dave	Excel Worksheet Functions	1	November 3rd 04 07:21 PM

All times are GMT +1. The time now is 06:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us