VBA to use Selection.Address in a formula

I have this bit of code

Code:

---

Range("H" & iRow).Resize(cRng, 12).Select
addr = Selection.Address

---

I am trying to get this formula into a cell using VBA
=ColorFunction($IE$1,$H2:$S3,TRUE)

So that it says

Code:

---

ActiveSheet.Range("IG2").Formula = "=ColorFunction($IE$1,$H2:$S3,TRUE)”

---

$ID$1, $IE$1, $IF$1 is from the color that we’re looking for.
I may put the selected value into a variable.
addr is $H2:$S3 BUT $H2:$S3 is also located in cell HY1

How do I code this "=ColorFunction($IE$1 ,addr,TRUE)”

=ColorFunction($IE$1 ," & addr & ",TRUE)”

..

arnelgp: Thanks.
It works.

Code:

---

      addr = Selection.Address
      ActiveSheet.Range("IG2").Formula = "=ColorFunction($IE$1 ," & addr & ",TRUE)"

---