khalid79m
12-01-2008, 07:52 AM
=IF(COUNTBLANK($X3:$AD3),"Data Missing","Complete")
My current code, looks at x3 to ad3 and see if there are any blanks , if yes then "Data Missing" , "Complete"
I need the code to rather than look at x3 to ad3 , look at ranges "Que_1! and "Que_2", "Que_3", "Que_4" and "Que_5"
How can this be done ?
This is my current code:
'Call Checker
With Range("AN3:AN" & lastrow)
.FormulaR1C1 = "=IF(COUNTBLANK($X3:$AD3),"Data Missing","Complete")
.Value = .Value
End With
I want it to
'Call Checker
With Range("Call_Checke")
.FormulaR1C1 = "=IF(COUNTBLANK('!!!put the ranges in here ),"Data Missing","Complete")
.Value = .Value
End With
My current code, looks at x3 to ad3 and see if there are any blanks , if yes then "Data Missing" , "Complete"
I need the code to rather than look at x3 to ad3 , look at ranges "Que_1! and "Que_2", "Que_3", "Que_4" and "Que_5"
How can this be done ?
This is my current code:
'Call Checker
With Range("AN3:AN" & lastrow)
.FormulaR1C1 = "=IF(COUNTBLANK($X3:$AD3),"Data Missing","Complete")
.Value = .Value
End With
I want it to
'Call Checker
With Range("Call_Checke")
.FormulaR1C1 = "=IF(COUNTBLANK('!!!put the ranges in here ),"Data Missing","Complete")
.Value = .Value
End With