| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for 0, then offset down 310, left 4, Check for = 0
I am trying to come up with a procedure that checks a Range(€œE3:E300) and if
any value is 0 then Offset(310, -4) so I go down 310 rows and over to Column A, and then look at the value in that cell. If the value in that cell is equal to 0, then CALL A SUB in another module. When the sub finishes, put a 1 in that cell, down 310 and over to the left 4. So, the next time I run this loop, if I checks a Range(€œE3:E300) and if any value is 0 then Offset(310, -4) so I go down 310 rows and over to Column A, and then look at the value in that cell. If the value in that cell is equal to 1, DONT CALL THE SUB. TIA! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop through column(s) to check values, perform action based on check | Excel Programming | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| check.offset | Excel Programming | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Can Vlookup check a cell to the left? | Excel Worksheet Functions | |||
Threaded Mode
