keentolearn
10-21-2008, 05:35 AM
Hi,
Cells(compLDR + 1, 6) = Application.WorksheetFunction.Sum(COMPR.Range("F3:F" & compLDR))
The above code is working well. But if I want it to write it as below it is not working
Cells(compLDR + 1, 6).Formula = " =Sum(COMPR.Range("F3:F" & compLDR))"
As I am very much a starter in VBA I couldn't make it this.
Any help is appreciated.
Cells(compLDR + 1, 6) = Application.WorksheetFunction.Sum(COMPR.Range("F3:F" & compLDR))
The above code is working well. But if I want it to write it as below it is not working
Cells(compLDR + 1, 6).Formula = " =Sum(COMPR.Range("F3:F" & compLDR))"
As I am very much a starter in VBA I couldn't make it this.
Any help is appreciated.