= sum error 1

[tyone]

#NAME?

the code behind this:
ActiveSheet.Cells(lngRow, 7).Formula = "=sum(rng:rng1)"

rng and rng1 shows the cells that they should be like $G$2 and $G$5.

Thanks in advance

 

[PHV]

Provided rng and rng1 are strings:
ActiveSheet.Cells(lngRow, 7).Formula = "=SUM(" & rng & ":" & rng1 & ")"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tyone]

thanks PHV was just what i was looking for....

 

[tyone]

why does it need the & symbol in there. just curious. also is there a way to bold those cells also.

thanks so much in advance

 

[PHV]

& is the string concatenation operator.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[xlbo]

Range.Font.Bold = true

the way you had it written, the formula entered into the cell would be

=SUM(rng:rng1)

which excel cannot recognise

Becuase you are holding rng & rng1 as variables, you must insert them into the formula string as seperate entities (as PHV has shown you)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question