Thread: VB doesn't like this Formula?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
DISMfish DISMfish is offline
external usenet poster
  
Posts: 22
Default VB doesn't like this Formula?
Ok, I changed to the following, but I'm still getting an error...?

Last_Column.Formula = "=IF(OR( _
AND("" & RF_Min_Limit & ""<=Q2,"" & RF_Max_Limit & ""=Q2), _
AND("" & RF_Min_Limit & ""<=R2,"" & RF_Max_Limit & ""=R2), _
AND("" & RF_Min_Limit & ""=Q2,"" & RF_Max_Limit & ""<=R2)),1,0)"

Reply With QuoteReply With Quote