Re: $$Excel-Macros$$ how to process parallel ranges with 'for each'

2017-05-01 Thread Paul Schreiner
how are you defining the corresponding cell?Is it the same cell in a different sheet?or is it the same "offset"That is:Range 1 is 3 rows x 3 columns beginning in cell A1 andRange 2 is 3 rows x 3 columns beginning in cell E1  there's lots of ways to do it.In some cases, you can hard-code the

$$Excel-Macros$$ how to process parallel ranges with 'for each'

2017-04-27 Thread Raymond Jerome
I want to take 2 ranges, 1 dim each, can be 2 rows or 2 columns, but I need to take a cell from one range and do something with it's 'parallel' cell in the other range. for example, something like a root mean square deviation. One column is data values, other column is expected values and the