I have a process that needs to enter a formula into a cell
I'm not sure why but when this executes it returns 'TRUE' as text in the cell rather than the formula.
Can anyone advise as to whats going on here as I've not had a problem with entering formulas into cells before.
TIA
Code:
Range("Table_RowCount").Formula = "=COUNTIF(D5:D4999," > ")"
Can anyone advise as to whats going on here as I've not had a problem with entering formulas into cells before.
TIA