Inserting a Relative Formula into Cells

[mayoung]

I have the the following two formulas I would like to insert into a spreadsheet using a macro into cells G18:G31 and I18:I31. either through using a range, auto fill or copy/paste,
I need the formulas to be relative as relate to each reference cell 18,19,20 etc.

My problem is getting the correct formula to recognize the formula due to the select one.

Cell G18: =IF(COUNTIF(J18,"*SELECT ONE*"),"",F18*K18)

Cell I18: =IF(COUNTIF(J18,"*SELECT ONE*"),"",G18+H18)

Any Help would be appreciated.

 

[Jon von der Heyden]

Try:

Range("G18:G31").Formula = "=IF(COUNTIF(J18,""*SELECT ONE*""),"""",F18*K18)"

Follow same convention for the 2nd one.

 

[mayoung]

Try:

Range("G18:G31").Formula = "=IF(COUNTIF(J18,""*SELECT ONE*""),"""",F18*K18)"

Follow same convention for the 2nd one.

When I enter the code I get this error? (see attached picture.)

 

[Jon von der Heyden]

WHat formula is in F18 and K18? If you say OK to that message, which cell does it refer to as containing the circular reference?

 

[mayoung]

WHat formula is in F18 and K18? If you say OK to that message, which cell does it refer to as containing the circular reference?

I figured it out. Your formula worked I just forgot to change my cell range on the second formula.

Thank You!!

 

[Jon von der Heyden]

super