Hiro
All American
4673 Posts
user info
edit post |
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
Else
IsColor = 1
End If
End Function
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
|
