Thank you sir & one more small help can we do with any vbaTry
=IF(AND(A2="",B2=""),"",A2+B2)
what do mean we can't ask a question like thisSeems a bit pointless really
VBA Code:Sub MM1() With Range("C2:C10") .Formula = "=IF(AND(A2="""",B2=""""),"""",A2+B2)" .Value = .Value End With End Sub
yes your correct & why i asked for vba if i apply formula in cell and when i edit that cell it will display formula if i apply with vba then it's never display formula in cell when i edit that cellNo I mean that using VBA to carry out a native Excel function seems pointless
The formula can be inserted in 1 cell to apply to ALL other cells in the column......why use VBA to do the same thing