Help: Nested If/And Function formula to VB code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an inefficient, but working, nested if-and worksheet function formula
that I need to put into a macro. I almost got "do-looped" to death today.
Any help or direction would be most appreiciated. - Randy


Range("H11").Select (Activecell)
ActiveCell.Formula =
"=IF(AND(B11=24,B18=24,B25=24,B32=24,B39=24,B46=24,B53=24,B60=24),TRUE,FALSE)"

If ActiveCell = True Then

Else:
 
Earl,
Thank you so much for the help. I chose the Do-Loop, because I will only
have to change one variable if I add another "range of 7". I'm trying to
use/learn as many different techniques in this project as I can. Do-Loop won
the battle this time with me, but I now have a working model to examine.
Many thanks,
Randy
 
Back
Top