Posted to microsoft.public.excel.programming

Jeff

external usenet poster

Posts: 921

Sorting sheets in workbook

I have a workbook that has sheets in it that are sheet1 €“ sheet33. I tried to
use the code from http://cpearson.com/excel/sortws.htm The problem is
that it does not handle the numbers in the sheet in the right order. It puts
them Sheet1, Sheet10, Sheet11, Sheet12...before it gets to Sheet2. Any ideas?
Thanks! Jeff

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro for filter on protected workbook that works for all sheets, no matter what sheets are named?	StargateFanFromWork[_3_]	Excel Programming	6	January 26th 06 06:31 PM
Sorting Sheets in a Workbook	Mnj 78	Excel Programming	2	October 12th 04 06:39 PM
Sorting sheets in Workbook	Mnj 78[_2_]	Excel Programming	2	October 12th 04 05:41 PM
Sorting Sheets in a workbook	Mnj 78[_2_]	Excel Programming	1	October 12th 04 05:26 PM
Sorting Sheets in Workbook	Mnj 78[_2_]	Excel Programming	1	October 12th 04 05:26 PM

All times are GMT +1. The time now is 08:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us