K
Kelvin
Sub RIRthreedates()
Range("m3").Formula = "=IF(count(i3:k3)<3,"",if(i3>j3,i3,if(j3>k3,
j3,k3)))" End Sub
This subR causes a runtime error " application defined or object defined
error" 1004
If I put the formula in the cell directly , it works fine.
if I use the equation Range("m2").Formula = "=counta(a3:a5)" in the
subR
it works fine.
why would the above line cause this error. Can someone shed some light????
thanks
Range("m3").Formula = "=IF(count(i3:k3)<3,"",if(i3>j3,i3,if(j3>k3,
j3,k3)))" End Sub
This subR causes a runtime error " application defined or object defined
error" 1004
If I put the formula in the cell directly , it works fine.
if I use the equation Range("m2").Formula = "=counta(a3:a5)" in the
subR
it works fine.
why would the above line cause this error. Can someone shed some light????
thanks