| 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 |
| 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) | |||
Threaded Mode
