The code goes in a general module inside that workbook's project (in the VBE).
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
zzxxcc wrote:
The cell where I put the function say #Name?. In detail, where do I copy in
the UDF? Tool - Macro - VBA - ? - ? - ?
--
Thanks
"Nick Hodge" wrote:
Mama
It's not standard functionality but you could put a UDF (User Defined
Function) in the workbook and then enter it in another column and sort by
that.
=ReturnColorIndex(A1)
UDF (Place in a standard module in the workbook)
Function ReturnColorIndex(rCell As Range) As Integer
Application.Volatile True
ReturnColorIndex = rCell.Interior.ColorIndex
End Function
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"mama" wrote in message
...
Version excel 2003
--
Dave Peterson