On 2002-03-24 15:25, kwaring wrote:
Range("A5").Select
ActiveCell.FormulaR1C1 = SUM(A1:A4)
Trying to do something like this but the compiler doesn't like the syntax... any suggestions?
Thanks,
Kyle
On 2002-03-24 15:25, kwaring wrote:
Range("A5").Select
ActiveCell.FormulaR1C1 = SUM(A1:A4)
Trying to do something like this but the compiler doesn't like the syntax... any suggestions?
Thanks,
Kyle
This message was edited by kwaring on 2002-03-24 17:13
On 2002-03-24 16:45, kwaring wrote:
Thanks Jay and dk, however, I am still having problems... Your code works on the simple examples above and I thought I could incorporate that into my more-complex code but it still doesn't work.
Range("E" & Search) = "=SUM("E" & Start & ":" & "E" & Search)"
Where Search and Start are variables defined in VBA. When I try to run the macro, I get a Run-time error '1004': Application-defined or object-defined error
Thanks,
Kyle