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.