Adding formula to a cell

[mikeymay]

I have a process that needs to enter a formula into a cell

Range("Table_RowCount").Formula = "=COUNTIF(D5:D4999," > ")"

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

 

[FormR]

Hi - You need to double up the quotes:

Range("Table_RowCount").Formula = "=COUNTIF(D5:D4999,"">"")"

 

[mikeymay]

Ah...of course.....schoolboy error.


Thanks!