Convert formula to VBA

[rdw72777]

How would i convert the following formula (that works) to VBA, assuming row 3 is a VBA variable called myrow, column C is a variable (numeric) called col1 and column h is is a variable (numeric) called col2:

=SUM(IF(FREQUENCY(C3:H3,C3:H3)>0,1))

I tried:

Evaluate("=SUM(IF(FREQUENCY(" & Range(Cells(myrow, col1), Cells(myrow, col2)) & "," & Range(Cells(myrow, col1), Cells(myrow, col2)) & ")>0,1))")

 

[Andrew Poulsom]

Try adding .Address to the Range property.

 

[rdw72777]

Perfect it worked. I wish I never forgot these types of things, far more annoying than the hard stuff.