Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have the following in a spreadsheet: I J 1 1.0 1.0 2 2.0 0.3 3 1.0 4 1.2 5 2.3 2.3 I would like to be able to put some code behind that loops through the above range checks to see if for example the sum of I1:J1 is equal or greater than 2 and then throw up a msgbox otherwise do nothing. Is this possible? normally i would keep working at it but the project i am on is due by end of today so thankyou all in advance for any help you can provide. 8-) Tanya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
checking two different cells | Excel Worksheet Functions | |||
Checking cells contain a value | Excel Programming | |||
Checking range of cells for entry then checking for total | Excel Programming | |||
Checking the Cells in Sheet1 with Cells in Sheet2 and replace | Excel Worksheet Functions | |||
copying cells by checking color of the cells | Excel Programming |