View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default 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''.