Thread: how do I change the fill collor os a cell using a function in VB
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason R Morris
 
Posts: n/a
Default how do I change the fill collor os a cell using a function in VB
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.
Reply With QuoteReply With Quote