LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default loop through cells in a range and pick up corresponding cell values in another range

A have a set of rectangular ranges (20 rows and 5 columns) and I want
to loop through each cell, taking the values in the various cells as
inputs and populating the corresponding cell in another range with the
output.

That is to say:

inputA = Range("C7:G26")
inputB = Range("K7:O26")
output = Range("C30:G49")

The output is the result of the worksheet functions.

Assuming my function is output = A + B, I want to loop through so that:

C30.value = C7.value + K7.value
D30.value = D7.value + L7.value
....
C31.value = C8.value + K8.value
....
G49.value = G26.value + O26.value

What's the best way to achieve this?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import values from a cell or a range of cells Sri Harsha[_2_] Excel Worksheet Functions 0 September 8th 09 09:04 AM
How do i pick up a list of invoice numbers on a range of cells oasalako1 Excel Discussion (Misc queries) 3 October 18th 07 11:53 AM
how to pick from a range of table values jackoat Excel Worksheet Functions 5 August 2nd 05 08:50 PM
How do I Pick a cell with highest value from a range of cells? Chappy1648 Excel Worksheet Functions 1 May 19th 05 01:55 PM
using cell values to select range of cells Ray[_9_] Excel Programming 4 October 10th 03 08:31 AM


All times are GMT +1. The time now is 09:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"