Excel - Change cell formula from nested IFs to ??

[crptcblade]

I need more info on what type of event you need to call this from.

It would need to be a replacement for a formula in a range of cells. Basically, each cell in column K has that formula in it, but new values will be getting added regularly, and I don't want to have to maintain that big IF statement.

The only event I found was Sheet_Calculate, but I don't know how to figure out which cell has changed in order to update it.


As for the teeth, please transfer $458 for s/h to my Paypal and they are as good as yours.

[crptcblade]

Resolved by me. I figured out how to link a function in a module to the formula.

So I'll keep the teeth.

:evil:

[Br1an_g]

hi,

can you post how you achieved the resolution?

I would be interested to know.

Thnx

[crptcblade]

hi,

can you post how you achieved the resolution?

I would be interested to know.

Thnx

It actually turned out to be pretty easy. Add a module, and make a public function.

 Public Function ReturnSomeValue(CellValue) As Double
   ReturnSomeValue = Val(CellValue) * 2.24
 End Function

Then make the formula in the cell "=ReturnSomeValue(H4)" and it should work fine. I guess it gets a little hinky passing ranges of cells in, I only needed to worry about one cell at a time.

[RobDog888]

Resolved by me. I figured out how to link a function in a module to the formula.

So I'll keep the teeth.

:evil:

Geez, you welch on the teeth and you dont want to share the solution. Boooo *SLAP*

Should I give you -Teeth then