Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
= sign in formula changes to + when adding a cell or name | Excel Discussion (Misc queries) | |||
Automatic adding in a single cell w/o equal sign | Excel Worksheet Functions | |||
Rounding to integers and adding plus sign | Excel Discussion (Misc queries) | |||
Adding - sign(-) | Excel Programming | |||
Equal Sign Issue | Excel Worksheet Functions |