![]() |
#1
|
|||
|
|||
![]()
I have data in cells A1 through D10 and in column F( F1:F10) I have the averages of each row. I'd like to loop through the range of cells (A1 to D10) and within each row (10 rows) I want to compare the cell value to the corresponding row value in column F(average which is already computed.) Thanks in advance!
I have this so far: For Each c In Worksheets("Sheet1").Range("a1:d10").Cells [code to compare c.value to its corresponding F column value] Next |
Tags |
loop, range |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
TBD | Excel | 3 | 06-09-2014 06:14 AM |
![]() |
shabbaranks | Excel | 17 | 05-13-2014 06:47 PM |
How do you loop through an array with some empty values? | omahadivision | Excel Programming | 5 | 11-28-2013 10:49 AM |
change values based on cell | ubns | Excel | 1 | 05-21-2012 06:28 PM |
![]() |
flackend | Excel | 2 | 08-26-2011 07:01 AM |