View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hotherps[_48_] hotherps[_48_] is offline
external usenet poster
 
Posts: 1
Default refer to a formula for use in a loop

Is there a way to loop through a range of cells referring to a formul
on the active sheet? My formula works but I need it to continue t
evalute cells as it goes through the loop.

I do not want to use the formula directly in the cells because ther
are too many cells in the loop

I want to loop this formula :

=IF(AND(D$1=$B2,D$1<=$C2,$E$24=$AK$1,$AK2="X",$E3 4$E25),$E$24,"")

Through the range of D2:EI17

Thank

--
Message posted from http://www.ExcelForum.com