Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add and Subtract ranges (with multiple cells) in vba
I'm trying to subtract one range from another, but instead of looping through
cell by cell, I think it should be possible to perform this opeation in only a line or two. Below is the code for what I'm trying to do. Starting_HC, Final_HC and Turnover are all named ranges with 17R and 11C. Any ideas on what I can change to make this work? Sub Headcount() Range("Final_HC").Value = Range("Starting_HC").Value - Range("Turnover").Value End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add and Subtract ranges (with multiple cells) in vba
"Jon5001" wrote in message
... I'm trying to subtract one range from another, but instead of looping through cell by cell, I think it should be possible to perform this opeation in only a line or two. Below is the code for what I'm trying to do. Starting_HC, Final_HC and Turnover are all named ranges with 17R and 11C. Any ideas on what I can change to make this work? Sub Headcount() Range("Final_HC").Value = Range("Starting_HC").Value - Range("Turnover").Value End Sub Hi Jon, Here's one way to do it. It takes advantage of the fact that you can perform basic mathematical operations with the PasteSpecial method. Sub Headcount() Range("Final_HC").Value = Range("Starting_HC").Value Range("Turnover").Value.Copy Range("Final_HC").Value.PasteSpecial _ Paste:=xlValues, Operation:=xlSubtract End Sub -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter value zero into all cells in multiple ranges? | Excel Discussion (Misc queries) | |||
Counting Criteria in Cells in Multiple Ranges | Excel Worksheet Functions | |||
How do you multiple, subtract and divide in the Excel program? | Excel Worksheet Functions | |||
add and subtract multiple text strings. | Excel Discussion (Misc queries) | |||
Multiple Criteria (add or subtract) | Excel Discussion (Misc queries) |