Hi

I'm adding two rows with

with ActiveSheet
Range("D12").formula ="B12+C12"
Lrow = Range("C" & Rows.count).end(xlup).row
Range("D12" & Lrow).filldown
End With

it doesn't work when I have a negatif value. It's adding like if it was a
positif value. I changed the category of the row to number but when I'm
running that macro then it sends back the category to General. I'm biginning
in excel can you tell me what to do ?

My second question is when I have to add a $ in my macro like example
($A1:$B1)? Do you have a web site where I can learn about it?

Thanks
Jack

with ActiveSheet
Range("D12").formula ="=B12+C12" ' add an equal sign
Lrow = Range("C" & Rows.count).end(xlup).row
Range("D12" & Lrow).filldown
End With

for building a formula that uses $,
In Excel help, look at absolute and relative references.

As an argument to the Range object, you never need to use $.

--
Regards,
Tom Ogilvy

"Barb" wrote:

> Hi
>
> I'm adding two rows with
>
> with ActiveSheet
> Range("D12").formula ="B12+C12"
> Lrow = Range("C" & Rows.count).end(xlup).row
> Range("D12" & Lrow).filldown
> End With
>
> it doesn't work when I have a negatif value. It's adding like if it was a
> positif value. I changed the category of the row to number but when I'm
> running that macro then it sends back the category to General. I'm biginning
> in excel can you tell me what to do ?
>
> My second question is when I have to add a $ in my macro like example
> ($A1:$B1)? Do you have a web site where I can learn about it?
>
> Thanks
> Jack

Thanks Tom,
It works but only for positive values. If I have -555+3 the value will be
558 instead of -552. Do you know what I have to do to keep the row in integer
instead of general category?

"Tom Ogilvy" wrote:

> with ActiveSheet
> Range("D12").formula ="=B12+C12" ' add an equal sign
> Lrow = Range("C" & Rows.count).end(xlup).row
> Range("D12" & Lrow).filldown
> End With
>
> for building a formula that uses $,
> In Excel help, look at absolute and relative references.
>
> As an argument to the Range object, you never need to use $.
>
> --
> Regards,
> Tom Ogilvy
>
> "Barb" wrote:
>
> > Hi
> >
> > I'm adding two rows with
> >
> > with ActiveSheet
> > Range("D12").formula ="B12+C12"
> > Lrow = Range("C" & Rows.count).end(xlup).row
> > Range("D12" & Lrow).filldown
> > End With
> >
> > it doesn't work when I have a negatif value. It's adding like if it was a
> > positif value. I changed the category of the row to number but when I'm
> > running that macro then it sends back the category to General. I'm biginning
> > in excel can you tell me what to do ?
> >
> > My second question is when I have to add a $ in my macro like example
> > ($A1:$B1)? Do you have a web site where I can learn about it?
> >
> > Thanks
> > Jack

B12: -555
C12: 3

Range("D12").formula ="=B12+C12"

gave me -552 in D12

format the cell to display an integer.

If you want it to actually hold an integer then change the formula to


Range("D12").formula ="=Round(B12+C12,0)"

or

Range("D12").Formula ="=Trunc(B12+C12,0)"

depending on what you want.

--
Regards,
Tom Ogilvy



"Barb" wrote:

> Thanks Tom,
> It works but only for positive values. If I have -555+3 the value will be
> 558 instead of -552. Do you know what I have to do to keep the row in integer
> instead of general category?
>
> "Tom Ogilvy" wrote:
>
> > with ActiveSheet
> > Range("D12").formula ="=B12+C12" ' add an equal sign
> > Lrow = Range("C" & Rows.count).end(xlup).row
> > Range("D12" & Lrow).filldown
> > End With
> >
> > for building a formula that uses $,
> > In Excel help, look at absolute and relative references.
> >
> > As an argument to the Range object, you never need to use $.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Barb" wrote:
> >
> > > Hi
> > >
> > > I'm adding two rows with
> > >
> > > with ActiveSheet
> > > Range("D12").formula ="B12+C12"
> > > Lrow = Range("C" & Rows.count).end(xlup).row
> > > Range("D12" & Lrow).filldown
> > > End With
> > >
> > > it doesn't work when I have a negatif value. It's adding like if it was a
> > > positif value. I changed the category of the row to number but when I'm
> > > running that macro then it sends back the category to General. I'm biginning
> > > in excel can you tell me what to do ?
> > >
> > > My second question is when I have to add a $ in my macro like example
> > > ($A1:$B1)? Do you have a web site where I can learn about it?
> > >
> > > Thanks
> > > Jack

Thanks Tom, it works!

"Tom Ogilvy" wrote:

> B12: -555
> C12: 3
>
> Range("D12").formula ="=B12+C12"
>
> gave me -552 in D12
>
> format the cell to display an integer.
>
> If you want it to actually hold an integer then change the formula to
>
>
> Range("D12").formula ="=Round(B12+C12,0)"
>
> or
>
> Range("D12").Formula ="=Trunc(B12+C12,0)"
>
> depending on what you want.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "Barb" wrote:
>
> > Thanks Tom,
> > It works but only for positive values. If I have -555+3 the value will be
> > 558 instead of -552. Do you know what I have to do to keep the row in integer
> > instead of general category?
> >
> > "Tom Ogilvy" wrote:
> >
> > > with ActiveSheet
> > > Range("D12").formula ="=B12+C12" ' add an equal sign
> > > Lrow = Range("C" & Rows.count).end(xlup).row
> > > Range("D12" & Lrow).filldown
> > > End With
> > >
> > > for building a formula that uses $,
> > > In Excel help, look at absolute and relative references.
> > >
> > > As an argument to the Range object, you never need to use $.
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "Barb" wrote:
> > >
> > > > Hi
> > > >
> > > > I'm adding two rows with
> > > >
> > > > with ActiveSheet
> > > > Range("D12").formula ="B12+C12"
> > > > Lrow = Range("C" & Rows.count).end(xlup).row
> > > > Range("D12" & Lrow).filldown
> > > > End With
> > > >
> > > > it doesn't work when I have a negatif value. It's adding like if it was a
> > > > positif value. I changed the category of the row to number but when I'm
> > > > running that macro then it sends back the category to General. I'm biginning
> > > > in excel can you tell me what to do ?
> > > >
> > > > My second question is when I have to add a $ in my macro like example
> > > > ($A1:$B1)? Do you have a web site where I can learn about it?
> > > >
> > > > Thanks
> > > > Jack