need sumbycolor function for Excel 2007

[Lincoln]

I want to add cells that have the same font color, or if that's not possible, the same background color. I found a few functions which claim to do this. I copied/pasted into VBA, but keep getting #NAME? errors.

This is the first time I have ever done Alt/F11 so I might be doing something wrong? I have saved as a macro-enabled worksheet (.xlsm)

Thanks

 

[Trevor G]

Welcome to the Forum, what have you tried? Can you show the code and also copy some data into your thread, it will help get a response that will provide a solution for you.

 

[Lincoln]

Thanks for your reply Trevor, I have solved the issue now. I can't believe how simple it was. I just had to 'enable macros'. There was a security warning on the tool bar that I hadn't seen because I was so focused on the problem, but when I finally saw the warning, I enabled macros and it all works now. Thanks