ActiveCell.FormulaR1C1 = "=+COUNTIF(R17 ,R[-1]C)"
How to add variable instead of 17
R17 to R&i
is giving error.. Kindly help
I want to "=+COUNTIF(R & i & ,R[-1]C)"
This is giving error..
How to put variable i
ActiveCell.FormulaR1C1 = "=+COUNTIF(R17 ,R[-1]C)"
How to add variable instead of 17
R17 to R&i
is giving error.. Kindly help
I want to "=+COUNTIF(R & i & ,R[-1]C)"
This is giving error..
How to put variable i
Last edited by dorabajji; 03-04-2020 at 01:33 PM.
ActiveCell.FormulaR1C1 = " & Range(?????????).value " & cells&" ,R[-1]C)"
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi mehmetcik,
I am not able to get it..
Can you provide me full formula in countif..
My actual formula is
countif(7,7,A7)
This i am trying to do in vba.. instead of 7 i want i
Hi,
I am getting error.. when i incorporate yours in countif.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks