Hello everyone,
I was trying to get a range into a formula:
I have found the solution while browsing on google.Cells(1, 11).Formula = "=COUNTIF(" & Countif.Address & ",J1)"
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.