Adding to rows - sign issue??
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
|