count if related problem

[akkinarula]

hi all,

i m having following formula in vba ,but it is not dispalying the result in target cells

astr1 = "'Rcl Mix'!R" & Trim(Str(i)) & "C2"
astr2 = "'Rcl Mix'!R" & Trim(Str(b)) & "C7"
str2 = "=CONCATENATE(" & astr1 & ","" "" " & "," & astr2 & ")"

crange1 = "G" & Trim(Str(i)) & ":H" & Trim(Str(i))
Range(crange1).Select
Sheets("Rcl Mix").Select

ActiveCell.FormulaR1C1 = _
"=COUNTIF('Customer''s Details'!R13C79:R262C79,str2)"


anybody having solution for this then plz help me

 

[akkinarula]

hi all,

i m having following formula in vba ,but it is not dispalying the result in target cells

astr1 = "'Rcl Mix'!R" & Trim(Str(i)) & "C2"
astr2 = "'Rcl Mix'!R" & Trim(Str(b)) & "C7"
str2 = "=CONCATENATE(" & astr1 & ","" "" " & "," & astr2 & ")"

crange1 = "G" & Trim(Str(i)) & ":H" & Trim(Str(i))
Range(crange1).Select
Sheets("Rcl Mix").Select

ActiveCell.FormulaR1C1 = _
"=COUNTIF('Customer''s Details'!R13C79:R262C79,str2)"



anybody having solution for this then plz help me

'i' is taken from loop and 'b' is initialize to 9
i think str2 is not taking the value in count if function.is there any other way to specify the str2 .



plz help me.