Trying to Write a Formula within a Cell that References Another Object

**derpin101** · 09-27-2014, 04:23 PM

Hi! I've been lurking for some time, but am hoping I could get some help on a little conundrum. To summarize the problem, I am trying to write an "IF" formula within an ActiveCell that references the first cell of the ActiveCell's row and another cell defined by the location of the ActiveCell.

So far, I've successfully defined all necessary objects, but now I need some help actually writing the formula within the cell. I've attached the code below. I would be grateful for any help or advice you could give me.

Please Login or Register  to view this content.

**AlphaFrog** · 09-27-2014, 05:14 PM

Hi and welcome to the forum.

I think you want to concatenate the variable's value within the formula string.

emptycell.FormulaR1C1Local = "=IF(RC[" & abcoffset & "]=RC[" & defoffset & "],0,1)"

**derpin101** · 09-28-2014, 12:56 AM

Thanks! This worked amazingly.

Trying to Write a Formula within a Cell that References Another Object

LinkBack

Thread Tools

Rate This Thread

Display

Trying to Write a Formula within a Cell that References Another Object

Re: Trying to Write a Formula within a Cell that References Another Object

Re: Trying to Write a Formula within a Cell that References Another Object

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Is it possible to write an IF statement containing multiple references to 2 other cells?

[SOLVED] Macro to write a formula with dynamic cell references

Object library invalid or contains references to object definitions that couldn't be found

Object References

Object Library References

Bookmarks

Bookmarks

Posting Permissions