User defined function to copy the cell color to another cell (actual painting the color).
I am looking to write a code for copying the color of one cell to another.
For eg iif I selected sell A1 and enter = copyColor(D1).
Want A1 to mirror the same color as D1.
This code does it, but its a macro
I want to have a User defined funciton so that I can handover to my users ( who cant dot VBA) and use it in any of the cells they want.Please Login or Register to view this content.
Please help!
Bookmarks