Is there any way to sort by shade?

Angela, have a look here for a way to do it,

http://www.cpearson.com/excel/SortByColor.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Angela" wrote in message
...
Is there any way to sort by shade?

Hi Angela,

See Chip Pearson's Sorting By color page at:

http://www.cpearson.com/excel/SortByColor.htm

---
Regards,
Norman



"Angela" wrote in message
...
Is there any way to sort by shade?

How do i get to the standard code module?

"Paul B" wrote:

Angela, have a look here for a way to do it,

http://www.cpearson.com/excel/SortByColor.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Angela" wrote in message
...
Is there any way to sort by shade?

Hi Angela,

Alt-F11 to go to the Visual Basic Editor
Insert | Module to insert a new standard module
Paste your code
Alt-F11 to return to Excel

You may wish to visit David McRitchie's 'Getting Started With Macros And
User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman



"Angela" wrote in message
...
How do i get to the standard code module?

"Paul B" wrote:

Angela, have a look here for a way to do it,

http://www.cpearson.com/excel/SortByColor.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Angela" wrote in message
...
Is there any way to sort by shade?

thanks so much - i will give it a try

thanks for all of your help!

"Norman Jones" wrote:

Hi Angela,

Alt-F11 to go to the Visual Basic Editor
Insert | Module to insert a new standard module
Paste your code
Alt-F11 to return to Excel

You may wish to visit David McRitchie's 'Getting Started With Macros And
User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman



"Angela" wrote in message
...
How do i get to the standard code module?

"Paul B" wrote:

Angela, have a look here for a way to do it,

http://www.cpearson.com/excel/SortByColor.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Angela" wrote in message
...
Is there any way to sort by shade?

Thanks for all of your help Paul!

"Paul B" wrote:

Angela, have a look here for a way to do it,

http://www.cpearson.com/excel/SortByColor.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Angela" wrote in message
...
Is there any way to sort by shade?