Add Funtion to cell

[Oilfield]

Why is this not working?

Please Login or Register  to view this content.

I want the VBA to drop the funtion "N10 + P10" into Cell O10 if Cell B2 contains the name CanPlus 750

[Norie]

Try this.

Please Login or Register  to view this content.

[Oilfield]

I actually need that to run automatically. Such as whenever there is a change on the sheet.

How do I do that?

[Oilfield]

Nevermind. I got that to work. But how do i get it to remove the formula if that B2 doesn't contain "CanPlus 750"?

[shg]

Please Login or Register  to view this content.

Seems like a dubious use of VBA ...

[Oilfield]

Well ****. Now it's throwing up an error. Run-time error'-2147417848 (80010108):': method "Range of object'-worksheet' failed

[Oilfield]

It probably is, but I don't know how else doing it.

[shg]

How about just a static formula in O10?

=IF(ISNUMBER(SEARCH("CanPlus 750", B2)), N10 + P10, "")

[Oilfield]

That is what I did at first. The problem is, that cell is used to enter data if it isn't a "CanPlus 750"... And I dont think you can input a function into a Cell based on another cells value.