Hi
not sure why you want to do this in VBA. what is your goal with this
(there may be a simple worksheet function to achieve this)?

--
Regards
Frank Kabel
Frankfurt, Germany


I have the following formula that works well:

=IF(AND(B2=D25,D25<=C2,E24=AK1,AK2="X",E34E25),E 24,"")

I want to loop this formula through each cell in range B2:BB100

The result that is returned E24:P24 is a cell with some text in it
that should be displayed in each cell that meets the criteria in the
row loop range.

But the references to cells in E34E25 and AK1 need to increment to
the next cell to the right (i.e. F34F25 and AL1 etc.) in the range
(E:P , AK:AV) each time the result of the formula is false or "".

Is this the right approach (long formula and loop)?
If so I need help writing the loop

Thanks!!


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