I have been using a simple "get color" function in Excel 2003 so that I can sort by color, sum by color, etc. By this I mean, I have an extra column in my spreadsheet where I type in =GetColor(A2) for example, and it gives me the color number. This works great for me, but now I am leaving for maternity leave and need to pass over my spreadsheet to another user. In fact, there will be up to 3 people that will be making changes in this file. I am having trouble getting that function to work for them also. When they save the file, it returns a #name error. Is there something else I can put in the code to get it to work for whoever opens the file?
Thanks so much!
This is the function I am using:
Function GetColor (Mycell as Range)
GetColor = Mycell.Interior.ColorIndex