View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Paul B
 
Posts: n/a
Default How to sort rows by Colors

Sheikh, sent you a file to look at

--
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

"Sheikh Saadi" wrote in message
...
Hi Paul,
could you please tell me where should I need to write those functions as

I
am totaly new to VBA programming. or if you could then send me a sample

file
in working condition at

I will be very greatfull to you.
--
Sheikh Saadi


"Paul B" wrote:

Sheikh, this is not a buit in function in excel, will be in the next
version, 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

"Sheikh Saadi" wrote in message
...
hi there,

can anybody help me out to sort the rows by Colors. like I have two

colored
rows Light Green and Light Yellow and some are without colors. how do

i
sort
them that same colors come with eachother?
--
Sheikh Saadi