Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
Hi
Is it possible to sort by colour, with using an Add-in, as I am at work and will not permit any install tried the links to cpearson etc, but i see they were add-ins glad to use any VBA, if anyone has it, of point me in the direction? using Excel 2003 thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201003/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
Download the modcolorfunctions.zip file from
http://www.cpearson.com/excel/SortByColor.aspx Unzip the *.bas file and import as a module to any workbook. All the functions needed are in that module. Not an add-in.............nothing to install. Gord Dibben MS Excel MVP On Wed, 24 Mar 2010 13:37:42 GMT, "BNT1 via OfficeKB.com" <u19326@uwe wrote: Hi Is it possible to sort by colour, with using an Add-in, as I am at work and will not permit any install tried the links to cpearson etc, but i see they were add-ins glad to use any VBA, if anyone has it, of point me in the direction? using Excel 2003 thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
Follow this
http://www.datapigtechnologies.com/f...rtonColor.html -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "BNT1 via OfficeKB.com" wrote: Hi Is it possible to sort by colour, with using an Add-in, as I am at work and will not permit any install tried the links to cpearson etc, but i see they were add-ins glad to use any VBA, if anyone has it, of point me in the direction? using Excel 2003 thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201003/1 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
thank you both - did use the datapig as i was able to follow it easier
works perfect regards Russell Dawson wrote: Follow this http://www.datapigtechnologies.com/f...rtonColor.html Hi [quoted text clipped - 7 lines] thanks -- Message posted via http://www.officekb.com |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
thank you both - did use the datapig as i was able to follow it easier
works perfect regards Russell Dawson wrote: Follow this http://www.datapigtechnologies.com/f...rtonColor.html Hi [quoted text clipped - 7 lines] thanks -- Message posted via http://www.officekb.com |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
Hi
Works perfect when copy/paste in module this workbook. When copy/paste in personal.xls vba it doesnt seem to work Function getcolour(mycell As Range) getcolour = mycell.Interior.ColorIndex End Function Am i doing something wrong? regards BNT1 wrote: thank you both - did use the datapig as i was able to follow it easier works perfect regards Follow this [quoted text clipped - 5 lines] thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201003/1 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
=Personal.xls!getcolour(range)
Gord On Thu, 25 Mar 2010 11:51:22 GMT, "BNT1 via OfficeKB.com" <u19326@uwe wrote: Hi Works perfect when copy/paste in module this workbook. When copy/paste in personal.xls vba it doesnt seem to work Function getcolour(mycell As Range) getcolour = mycell.Interior.ColorIndex End Function Am i doing something wrong? regards BNT1 wrote: thank you both - did use the datapig as i was able to follow it easier works perfect regards Follow this [quoted text clipped - 5 lines] thanks |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
thanks Gord
where do i paste this "=Personal.xls!getcolour(range)" in the code below (as you may of guessed, i'm upto spped with this VBa Function getcolour(mycell As Range) getcolour = mycell.Interior.ColorIndex End Function Have tried: Function Personalxls!getcolour(mycell as range) getcolour = mycell.Interior.ColorIndex End Function but got error thanks in advance Gord Dibben wrote: =Personal.xls!getcolour(range) Gord Hi [quoted text clipped - 19 lines] thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201003/1 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
You type Gord's suggestion into a cell in the worksheet.
For instance, to get the interior colorindex of the cell in A1, you could type this into B1: =Personal.xls!getcolour(A1) ===== The code itself would go into a general module of the personal.xls workbook's project. I'm not sure if you put that in the correct location, though. If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) "BNT1 via OfficeKB.com" wrote: thanks Gord where do i paste this "=Personal.xls!getcolour(range)" in the code below (as you may of guessed, i'm upto spped with this VBa Function getcolour(mycell As Range) getcolour = mycell.Interior.ColorIndex End Function Have tried: Function Personalxls!getcolour(mycell as range) getcolour = mycell.Interior.ColorIndex End Function but got error thanks in advance Gord Dibben wrote: =Personal.xls!getcolour(range) Gord Hi [quoted text clipped - 19 lines] thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201003/1 -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
worked a treat
Dave Peterson wrote: You type Gord's suggestion into a cell in the worksheet. For instance, to get the interior colorindex of the cell in A1, you could type this into B1: =Personal.xls!getcolour(A1) ===== The code itself would go into a general module of the personal.xls workbook's project. I'm not sure if you put that in the correct location, though. If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) thanks Gord [quoted text clipped - 27 lines] Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201003/1 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201003/1 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by colour
Thanks Dave
Gord On Thu, 25 Mar 2010 09:44:47 -0500, Dave Peterson wrote: You type Gord's suggestion into a cell in the worksheet. For instance, to get the interior colorindex of the cell in A1, you could type this into B1: =Personal.xls!getcolour(A1) ===== The code itself would go into a general module of the personal.xls workbook's project. I'm not sure if you put that in the correct location, though. If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) "BNT1 via OfficeKB.com" wrote: thanks Gord where do i paste this "=Personal.xls!getcolour(range)" in the code below (as you may of guessed, i'm upto spped with this VBa Function getcolour(mycell As Range) getcolour = mycell.Interior.ColorIndex End Function Have tried: Function Personalxls!getcolour(mycell as range) getcolour = mycell.Interior.ColorIndex End Function but got error thanks in advance Gord Dibben wrote: =Personal.xls!getcolour(range) Gord Hi [quoted text clipped - 19 lines] thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201003/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by colour | Excel Discussion (Misc queries) | |||
Sort Colour | Excel Discussion (Misc queries) | |||
possible to sort by colour?? | Excel Discussion (Misc queries) | |||
sort by colour | Excel Discussion (Misc queries) | |||
Sort by Colour? | Excel Worksheet Functions |