excel formula problem

Hi,

From vb i am generating the excel sheet. For example
this is the sample excel file i am generating.

A B
content1 Minutes 11
Content2
Content3
content4 Minutes 44
content5
content6 Minutes 88

A,B Columns.

and end of the row. i have to add all the minutes like
11+44+88
and put it in seperat row. i try to place the =SUM
(B1:B19) like this.
But its say error.like its not a valid number.

how to solve the problem?
pls help me.

Thanks
balakumar

Justin
Fri Nov 21 14:47:23 CST 2003

Record a macro, perform the same operation, and look at the code.

Justin

"Balakumar" <pmmbala@lycos.com> wrote in message
news:01aa01c3b06a$793f4f40$a401280a@phx.gbl...
> Hi,
>
> From vb i am generating the excel sheet. For example
> this is the sample excel file i am generating.
>
> A B
> content1 Minutes 11
> Content2
> Content3
> content4 Minutes 44
> content5
> content6 Minutes 88
>
> A,B Columns.
>
> and end of the row. i have to add all the minutes like
> 11+44+88
> and put it in seperat row. i try to place the =SUM
> (B1:B19) like this.
> But its say error.like its not a valid number.
>
> how to solve the problem?
> pls help me.
>
> Thanks
> balakumar
>
>

Balakumar
Fri Nov 21 15:36:22 CST 2003

hi,

i am sorry. i dont have idea reg macro. can u please give
me an example. so then i can apply in my program.

Thanks
balakumar
>-----Original Message-----
>Record a macro, perform the same operation, and look at
the code.
>
>Justin
>
>"Balakumar" <pmmbala@lycos.com> wrote in message
>news:01aa01c3b06a$793f4f40$a401280a@phx.gbl...
>> Hi,
>>
>> From vb i am generating the excel sheet. For example
>> this is the sample excel file i am generating.
>>
>> A B
>> content1 Minutes 11
>> Content2
>> Content3
>> content4 Minutes 44
>> content5
>> content6 Minutes 88
>>
>> A,B Columns.
>>
>> and end of the row. i have to add all the minutes like
>> 11+44+88
>> and put it in seperat row. i try to place the =SUM
>> (B1:B19) like this.
>> But its say error.like its not a valid number.
>>
>> how to solve the problem?
>> pls help me.
>>
>> Thanks
>> balakumar
>>
>>
>
>
>.
>

Jeff
Fri Nov 21 16:14:08 CST 2003


"Balakumar" <anonymous@discussions.microsoft.com> wrote in message
news:03ed01c3b077$81ca6e30$a301280a@phx.gbl...

> i am sorry. i dont have idea reg macro. can u please give
> me an example. so then i can apply in my program.

Tools | Macro | Record

And these questions really belong in microsoft.public.excel.programming.