Sorting Data with Named Ranges

**kzmr1234** · 08-18-2010, 01:10 PM

I saw this same questions asked on an earlier posting and I tried to follow it but wasn't able to since I'm new to VBA.

I have a worksheet containing about 175 single cell named ranges and I want to be able to sort the data by different line numbers (there are three different columns containg the three different line numbers) without scrambling the named ranges.

I've attached the worksheet if anyone can HELP.

Thanks from California

**TMS** · 08-18-2010, 01:27 PM

What was the earlier posting? Can you provide the URL?

Regards

**kzmr1234** · 08-18-2010, 01:49 PM

http://www.excelforum.com/excel-prog...med-range.html

**TMS** · 08-18-2010, 02:51 PM

Sorry, didn't realise that there was no attachment. Can you supply?

It would be useful to have a before and after view so we know what we're aiming for.

Regards

**kzmr1234** · 08-18-2010, 04:28 PM

..........

**TMS** · 08-18-2010, 05:34 PM

No attachment?

You need to select "Go Advanced", click on the paperclip icon, browse to a file and then click on "upload"

Regards

**kzmr1234** · 08-23-2010, 12:52 PM

Attached is the file that I need to sort based on 4 different Line # columns (highlighted in yellow)

There are approx. 30 single cell named ranges in the worksheet.

Any help is appreciated.

Thanks.