how do I change the fill collor os a cell using a function in VB
Hi Jason,
A user defined function (UDF) returns a value; it cannot change formatting
or alter its environment
---
Regards,
Norman
"Jason R Morris" wrote in message
...
I am trying to us an if then statment in a function to change the fill
color
of a cell if the conditions are true. I have tried
"ActiveCell.Interior.ColorIndex = 6" that works in subs, but it does not
works in functions.
|