| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Worksheets in a workbook
Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but I
am not sure -- do I have to copy and save it into every worksheet? My workbook has 43 tabs so far. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting Worksheets in a workbook
See http://www.ozgrid.com/VBA/sort-sheets.htm
-- Regards Dave Hawley www.ozgrid.com "Doehead" wrote in message ... Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but I am not sure -- do I have to copy and save it into every worksheet? My workbook has 43 tabs so far. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting Worksheets in a workbook
Hi Dave, I did as was instructed by the website but I got a 'Compile Error'
any idea why? "ozgrid.com" wrote: See http://www.ozgrid.com/VBA/sort-sheets.htm -- Regards Dave Hawley www.ozgrid.com "Doehead" wrote in message ... Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but I am not sure -- do I have to copy and save it into every worksheet? My workbook has 43 tabs so far. Thanks . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting Worksheets in a workbook
Remove the blank line between the below two lines...and Dave's code should
work fine. A space followed by _ is a line separator lReply = MsgBox("To sort ............. & "To sort Worksheets ........... 'remove the blank line (as below) so that VBE considers this as one line lReply = MsgBox("To sort ............. & "To sort Worksheets ........... -- Jacob (MVP - Excel) "Doehead" wrote: Hi Dave, I did as was instructed by the website but I got a 'Compile Error' any idea why? "ozgrid.com" wrote: See http://www.ozgrid.com/VBA/sort-sheets.htm -- Regards Dave Hawley www.ozgrid.com "Doehead" wrote in message ... Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but I am not sure -- do I have to copy and save it into every worksheet? My workbook has 43 tabs so far. Thanks . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting Worksheets in a workbook
Thanks Jacob, damn line breaks :)
-- Regards Dave Hawley www.ozgrid.com "Jacob Skaria" wrote in message ... Remove the blank line between the below two lines...and Dave's code should work fine. A space followed by _ is a line separator lReply = MsgBox("To sort ............. & "To sort Worksheets ........... 'remove the blank line (as below) so that VBE considers this as one line lReply = MsgBox("To sort ............. & "To sort Worksheets ........... -- Jacob (MVP - Excel) "Doehead" wrote: Hi Dave, I did as was instructed by the website but I got a 'Compile Error' any idea why? "ozgrid.com" wrote: See http://www.ozgrid.com/VBA/sort-sheets.htm -- Regards Dave Hawley www.ozgrid.com "Doehead" wrote in message ... Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but I am not sure -- do I have to copy and save it into every worksheet? My workbook has 43 tabs so far. Thanks . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting Worksheets in a workbook
Download the bas module zip file from http://www.cpearson.com/Zips/modSortingWorksheets.zip, save it to some folder (it doesn't matter where), and unzip the file. In VBA, go to the File menu, choose Import and import the unzipped module. Run the Sub named SortTheSheets to sort all the worksheets in the workbook using the default values for the parameters to the main sort procedure. You need only one copy of the code, but the code must reside in a code module, not one of the Sheet modules and not the ThisWorkbook code module. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Wed, 19 May 2010 17:54:01 -0700, Doehead wrote: Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but I am not sure -- do I have to copy and save it into every worksheet? My workbook has 43 tabs so far. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
| Sorting of No.Of Worksheets in a Workbook | Excel Discussion (Misc queries) | |||
| Sorting "State" Column onto separate worksheets in same workbook. | Excel Worksheet Functions | |||
| Sorting data in a workbook across multple worksheets | Excel Worksheet Functions | |||
| Sorting worksheets within a workbook | Excel Worksheet Functions | |||
Hybrid Mode
