Hi,
I am creating a macro, in that i am using COUNTIFS function like below
Activecell.FormulaR1C1= "=COUNTIFS(C:C,A" &ik &")"
ik = 1 to 10
In the cell it appear as =COUNTIFS(C:C,'A1') instead of =COUNTIFS(C:C,A1). So I am getting error. The apostrophe should not appear.
Any help would be greatly appreciated.
Thanks
Abdul
Bookmarks