Hi.
Excel 2007
I have a range of cells containing text data, listed under several headings.
I need to be able to select the individual group of headings and associated
data in the adjoining columns and sort it A - Z The problem is that although
the number of of columns is constant the number of rows is Variable and
increases as new data is added.
I am having trouble with the syntax of the macro to select Multiple rows and
columns.

Regards Keith B