WORKSHEET SORTING NOT WORKING?

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

FARAZ QURESHI

From the archives I was directed to:

http://www.cpearson.com/excel/sortws.aspx

I entered the entire 4 pieces of code:
1. SortWorksheetsByName;
2. SortWorksheetsByNameArray;
3. GroupSheetsByColor; and
4. Supportive code;

in a single module by:

1. Alt+F11;
2. Insert>Module;
3. Copying & pasting all the 4 parts;

Now I entered in one worksheet:
=SortWorksheetsByName(0,0,"NO")

The formula/function returns TRUE however how 2 make it work and do the
sorting of the worksheets???
 
This function was not meant to be called from a cell on a worksheet.

It was meant to be called from a different subroutine.
 
Sorry I couldn't understand how and from where to be called.

Would you kindly elaborate the same as a display?
 
The function is to be called from a subroutine or another function in your
code--not put in a formula in a cell.
 
Sorry still unclear despite of all my exercise during the whole night,

Kindly suppose,

I want to create 3 macros with shortcut key for all such three sorting
methods and add it in my MasterAddin.xla

What & How to do so?
 
Don't put the function in a formula in a worksheet.

Create a subroutine that calls the function, then use tools|macro|macros to run
that subroutine.

FARAZ said:
Sorry still unclear despite of all my exercise during the whole night,

Kindly suppose,

I want to create 3 macros with shortcut key for all such three sorting
methods and add it in my MasterAddin.xla

What & How to do so?
Click to expand...
 
Back
Top