Forum Discussion
How to sum in excel by colour
It works...you didn't include the modules in your workbook.
Maybe it was my negligence to inform you more about it,
in the heat of the writing battle I sometimes miss that the users
don't always have the same perspective.
Attached is the file corrected with the VBA modules.
Additional Infos/links:
Copy a macro module to another workbook
Create custom functions in Excel
Hope I could help you with that.
I wish you much success and fun with Excel.
I know I don't know anything (Socrates)
If I may recommend inserting the file (without sensitive data), describe your topic / problem step by step. In this way, you will receive a solution proposal that might fit your topic / problem much faster and more precisely and the helpers will save a lot of time in guessing the topic / problem beforehand. Information about the Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, etc.) would be of great advantage for everyone :).
Tnx for all help.
I am using Office 356 on win 10. I have send you an file of my test excell that I have make (copy from your file and modifyed). When I put your formula inside it just write inside name ...
If I open your file it is working if I copy conpleate page from your excell file to anew Excell it is not working any more.
It works...you didn't include the modules in your workbook.
Maybe it was my negligence to inform you more about it,
in the heat of the writing battle I sometimes miss that the users
don't always have the same perspective.
Attached is the file corrected with the VBA modules.
Additional Infos/links:
Copy a macro module to another workbook
Create custom functions in Excel
Hope I could help you with that.
I wish you much success and fun with Excel.
I know I don't know anything (Socrates)