Thread: Help: Nested If/And Function formula to VB code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RAP RAP is offline
external usenet poster
  
Posts: 49
Default Help: Nested If/And Function formula to VB code
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:

Reply With QuoteReply With Quote