selecting range for custom sort

**maacmaac** · 09-26-2010, 05:23 PM

I am trying to sort a range of values using private sub worksheet before double click. The following code works fine if I want to sort entire columns

Please Login or Register  to view this content.

However, I only want to sort A2:M44 as row 45 has totals. I tried to modify code as follows but keep receiving run time error. Any assistance appreciated.

Please Login or Register  to view this content.

**romperstomper** · 09-26-2010, 05:39 PM

If you double-click a cell that isn't in A1:M1, then SortColumn has no value.

**maacmaac** · 09-26-2010, 07:37 PM

Not quite what I was looking for. I have modified my example and attached a sample. If you open the sample, you will see I have a table (A1:D10). If I double click on any of the column headers, A1-D1, I want the table to sort on the column that is double clicked. However, in this example I only want to the data that is in A2:D9 sorted. The way the code is now, is it also sorts the data in row 10, which is the summary data. Thanks again for any comments.

**Leith Ross** · 09-26-2010, 07:48 PM

Hello maacmaac,

I changed the range to "A2:D9" and it works fine for me.

Please Login or Register  to view this content.

**maacmaac** · 09-26-2010, 08:25 PM

Now it is working. Thanks. I don't know why it wasn't working before.

**romperstomper** · 09-27-2010, 03:15 AM

I think you missed my point. If you double click a cell that is not the header row, your code still tries to sort, but sortcolumn has no value, so you should get an error.