The "equivalent" to your first line of code in A1 format is:

ActiveCell.Formula =
"=CONCATENATE(COUNTIF(Sheet1!F1:F8,""<1""),""/"",COUNT(Sheet1!F1:F8))"

IF the active cell is A1. Be sure that you understand the difference
between using the R1C1 and A1 reference styles though. There is no true
equivalent of the R1C1 macro in A1 format. The range referenced with the
R1C1 macro will always be dependent on what is the active cell when the
macro is run (the referenced range will start 5 columns to the right of it).
The A1 macro (above) will always reference the range F1:F8 regardless of the
active cell.

--
Jim Rech
Excel MVP