Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2015, 03:28 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Custom sort - two header_lines? Windows 7 64bit Custom sort - two header_lines? Office 2013
Advanced Beginner
Custom sort - two header_lines?
 
Join Date: Oct 2015
Posts: 79
Officer_Bierschnitt is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-19-2015, 07:48 AM
shg shg is offline Custom sort - two header_lines? Windows 7 64bit Custom sort - two header_lines? Office 2010 32bit
Advanced Beginner
 
Join Date: Oct 2015
Posts: 55
shg is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom sort - two header_lines? 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
Custom sort - two header_lines? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft