I'm trying to run a simple module that will assign a Boolean integer whether a cell is highlighted or not.
Here is my code in MVB
Function IsColor(x As Range) As Boolean
If x.Interior.ColorIndex <> xlColorIndexNone Then
IsColor = 0
IsColor = 1
I've renamed this module Color and returned my excel sheet, which is saved Macro-Enabled Wookbook *.xlsm
When I try to use the formula, for example =IsColor(C4), I am returned an #name? error. This is my first attempt at incorporating a macro. Someone please direct me to what I've done incorrectly? Thanks!!!
5/21/2015 11:24:02 PM