J
Jimmy
Can I sort worksheets in excel by names on tabs?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
J
Jimmy
Do I enter the "VBA code" as a formula?
Peo Sjoblom said:
D
Duke Carey
If you check the index on Chip's website, there are instructions on where to
place the code and how to use it. Look under VBA and or macros
place the code and how to use it. Look under VBA and or macros
D
Duke Carey
C
Chip Pearson
Jimmy,
Press ALT+F11 to open the VBA Editor. There, go to the Insert
menu and choose Module. In that code module, paste the code from
my web site. Go back to Excel, press ALT+F8 to bring up the
Macros dialog, and choose SortWS from the list.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Press ALT+F11 to open the VBA Editor. There, go to the Insert
menu and choose Module. In that code module, paste the code from
my web site. Go back to Excel, press ALT+F8 to bring up the
Macros dialog, and choose SortWS from the list.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
J
Jim Cone
Jimmy,
Download my free Excel add-in "Excel Extras" to sort sheets,
insert a Table of Contents and others.
Comes with an install/use Word file...
http://www.realezsites.com/bus/primitivesoftware
Jim Cone
San Francisco, USA
"Jimmy" <[email protected]>
wrote in message
Can I sort worksheets in excel by names on tabs?
Download my free Excel add-in "Excel Extras" to sort sheets,
insert a Table of Contents and others.
Comes with an install/use Word file...
http://www.realezsites.com/bus/primitivesoftware
Jim Cone
San Francisco, USA
"Jimmy" <[email protected]>
wrote in message
Can I sort worksheets in excel by names on tabs?