Formula in VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named Range maker code 9
Trouble Setting Range 5
Variable in Range for excel 2
combining text and variable in a .value 2
need some formula help please 8
nesting sum(if( help... 1
Excel VBA - Max Function - Syntax Error 1
Help on an IF formula 3

Back
Top