Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula in VB
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula in VB
Range("K3").Formula = "=SUM(H5:H" & MyCellNumber & ")"
-- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "donbowyer" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula in VB
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula in VB
So simple when you know, or perhaps I'm just tired!!
Thanks guys Don B -- donwb "Bob Phillips" wrote: Range("K3").Formula = "=SUM(H5:H" & MyCellNumber & ")" -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "donbowyer" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |