M
Matthew Dyer
I'm having some issues when trying to use a macro to generate formulas
in a worksheet.
Range("J10").Formula = "=count(e:e)"
This line works perfectly. Cell J10 will have the formula =count(E:E)
placed in it when the macro is ran. I tried to just follow the basic
setup using other formulas and I'm getting very frustrated...
Range("J11").Formula = "=SUMIF(D, " >= "&L12,E:E )"
Range("J12").Formula = "=COUNTIF(D, " >= "&L12)"
Both of the above lines return a boolean value instead of the actual
results of the sumif/countif formulas
Range("J14").Formula = "=SUMIF(E:E, ">39999",E:E )"
This above line gives me compie error - expected: end of statement???
Is there a simple way to have a macro place a formula into a specific
cell in a sheet?
in a worksheet.
Range("J10").Formula = "=count(e:e)"
This line works perfectly. Cell J10 will have the formula =count(E:E)
placed in it when the macro is ran. I tried to just follow the basic
setup using other formulas and I'm getting very frustrated...
Range("J11").Formula = "=SUMIF(D, " >= "&L12,E:E )"
Range("J12").Formula = "=COUNTIF(D, " >= "&L12)"
Both of the above lines return a boolean value instead of the actual
results of the sumif/countif formulas
Range("J14").Formula = "=SUMIF(E:E, ">39999",E:E )"
This above line gives me compie error - expected: end of statement???
Is there a simple way to have a macro place a formula into a specific
cell in a sheet?