AT--o
New Member
- Joined
- Aug 24, 2010
- Messages
- 19
Hi.
In excel 2007.
My function takes its arguments from cells on the same row that it is inserted. I just copy it down. The problem is I need to change the Interior of this cell (the one containing the function) according to values that while taken from operations between the arguments are not the value of the function. (otherwise I would use excel conditional formatting). I know the interior of a cell can't be changed by a function so...
Whats the code for the Sub? Im specially confuse about passing the arguments.
In excel 2007.
My function takes its arguments from cells on the same row that it is inserted. I just copy it down. The problem is I need to change the Interior of this cell (the one containing the function) according to values that while taken from operations between the arguments are not the value of the function. (otherwise I would use excel conditional formatting). I know the interior of a cell can't be changed by a function so...
Whats the code for the Sub? Im specially confuse about passing the arguments.