For Next Loop cell values

grexcelman · #1 01-22-2015, 08:48 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert non-cell input to cell values	TBD	Excel	3	06-09-2014 06:14 AM
Sum values within a single cell	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
Automatic, Dependent Cell Values	flackend	Excel	2	08-26-2011 07:01 AM