Edmond
02-15-2019, 08:08 AM
Hello everyone,
I was trying to get a range into a formula:
Cells(1, 11).Formula = "=COUNTIF(" & Countif.Address & ",J1)"
I have found the solution while browsing on google.
However, I don't understand why the typo has to be as herein-above.
Would you have some explanation about the "{Space}" and the "&"? I tried to find some explanations online but didn't find anything...
Thanks in advance for your time and help.
I was trying to get a range into a formula:
Cells(1, 11).Formula = "=COUNTIF(" & Countif.Address & ",J1)"
I have found the solution while browsing on google.
However, I don't understand why the typo has to be as herein-above.
Would you have some explanation about the "{Space}" and the "&"? I tried to find some explanations online but didn't find anything...
Thanks in advance for your time and help.