Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-22-2015, 08:48 AM
grexcelman grexcelman is offline For Next Loop cell values Windows 7 32bit For Next Loop cell values Office 2003
Novice
For Next Loop cell values
 
Join Date: Dec 2014
Posts: 21
grexcelman is on a distinguished road
Question For Next Loop cell values

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
Reply With Quote
 

Tags
loop, range



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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft