score:1

Accepted answer

this line: .add(type:=xlexpression, formula1:="=og(("c" & i)<=h8;("d" & i)>=h8)")

has improper quotes you took the c out of the quotes so it thinks its a variable and the ampersand is within the quotes so is being interpreted as a string character and not as the concatenation character.

you want something like: .add(type:=xlexpression, formula1:="=og((c" & i & ")<=h8;(d" & i & ")>=h8)")


Related Query

More Query from same tag