#1
|
|||
|
|||
Custom sort - two header_lines?
Hi,
I want to write a macro to do some simple things on an Excel file. That Excel file comes from Crystal_reports, our main reporting tool, and it has two header_lines - in the first, there is only the report_title and the second line has the actual headers. How can I do a custom sort on the entire table and tell Excel to consider two header_lines? When I tick that checkbox, then by default only one header_line is considered. Thanks a lot! Best regards, Officer_Bierschnitt |
#2
|
|||
|
|||
A header row is a single row to Excel.
You can offset the sort range by one row to ignore the row that contains the title. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Remove the * from the SubCate, Custom Sort, Replace..Help Please - I need. Thanks | shilabrow | Excel Programming | 2 | 07-10-2014 11:09 AM |
Custom table of contents referencing a custom field | skaboy607 | Word | 3 | 01-16-2014 06:59 AM |
assigning custom templates to custom tab | rich_cirillo | Word | 0 | 10-18-2012 05:59 PM |
Generic range for custom sort macro? | tswiers | Excel Programming | 2 | 08-11-2011 02:40 AM |
Sort Range | boutells | Excel | 1 | 07-15-2009 03:02 AM |