I want to apply formulae to a range of cells which mirrors certain data from another sheet using absolute referencing.
This is the format which I want to see:
=if(‘SheetName’!$’x’$’y’<>” ”,‘SheetName’!$’x’$’y’,” ”)

The code below does that successful when there is no condition applied, ie: ='First'!$D$7<>""

Replacing the active statement in the code with:
Range(Chr(64 + a) & b).Formula = "=if(‘First’!" & "$" & Chr(67 + a) & "$" & b <> "" & "," & "‘First’!" & "$" & Chr(67 + a) & "$" & b & "," & "" & ")"
places TRUE in each cell and no formula.

As far as I can see the statement above are correct, but the “,” does not seem to be recognised in both places. Replacing that set with chr(44) does not assist me.

Sub OtherSheet()

Sheets("Second").Select

For a = 1 To 2
For b = 7 To 133

Range(Chr(64 + a) & b).Formula = "='First'!$" & Chr(67 + a) & "$" & b
'                                 ='First'!$D$7<>""     ----- Entry in A1 for a=1, b=7
Next
Next
End Sub