Adding to rows - sign issue??
with ActiveSheet
Range("D12").formula ="=B12+C12" ' add an equal sign
Lrow = Range("C" & Rows.count).end(xlup).row
Range("D12:D" & 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:D" & 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
|