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. InsertModule;
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.

FARAZ QURESHI wrote:

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. InsertModule;
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???

--

Dave Peterson

Sorry I couldn't understand how and from where to be called.

Would you kindly elaborate the same as a display?

"Dave Peterson" wrote:

This function was not meant to be called from a cell on a worksheet.

It was meant to be called from a different subroutine.

FARAZ QURESHI wrote:

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. InsertModule;
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???

--

Dave Peterson

The function is to be called from a subroutine or another function in your
code--not put in a formula in a cell.

FARAZ QURESHI wrote:

Sorry I couldn't understand how and from where to be called.

Would you kindly elaborate the same as a display?

"Dave Peterson" wrote:

This function was not meant to be called from a cell on a worksheet.

It was meant to be called from a different subroutine.

FARAZ QURESHI wrote:

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. InsertModule;
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???

--

Dave Peterson


--

Dave Peterson

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?

"Dave Peterson" wrote:

The function is to be called from a subroutine or another function in your
code--not put in a formula in a cell.

FARAZ QURESHI wrote:

Sorry I couldn't understand how and from where to be called.

Would you kindly elaborate the same as a display?

"Dave Peterson" wrote:

This function was not meant to be called from a cell on a worksheet.

It was meant to be called from a different subroutine.

FARAZ QURESHI wrote:

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. InsertModule;
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???

--

Dave Peterson


--

Dave Peterson

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 QURESHI wrote:

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?

"Dave Peterson" wrote:

The function is to be called from a subroutine or another function in your
code--not put in a formula in a cell.

FARAZ QURESHI wrote:

Sorry I couldn't understand how and from where to be called.

Would you kindly elaborate the same as a display?

"Dave Peterson" wrote:

This function was not meant to be called from a cell on a worksheet.

It was meant to be called from a different subroutine.

FARAZ QURESHI wrote:

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. InsertModule;
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???

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson