Range("K3").Formula = "=SUM(H5:H" & MyCellNumber & ")"

--
Regards,
Tom Ogilvy


"donbowyer" wrote:

Excel 2003 on Win XP
The following code works:-
Range("K3").Formula = "=SUM(H5:H20)"
But I want to make the second half of the range definition
(ie the H20 bit) variable, something like:-
Range("K3").Formula = "=SUM(H5:H & MyCellNumber)"
but it fails, giving "error 2029."
I'm sure my syntax is wrong.
Would much appreciate some help with this.
--
donwb