k_v_deepu
09-02-2008, 06:37 AM
Hi Friends
I have a code as for below.
I want to assign the output of the formula to a variable and then test that variable for Null
if it is null i want to ignore the value else i have to print the value
can anyone help me on this
If ActiveCell.Offset(0, fixDateCol).Value = "ja" Then
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[" & repName & "],Fixed_Deliverdates_08!C[" & repName - 1 & "]:C[" & repName + monNum + 1 & "]," & monNum + 3 & ",0)"
End If
Cross Posted in http://www.mrexcel.com/forum/showthread.php?p=1672969#post1672969 also
I have a code as for below.
I want to assign the output of the formula to a variable and then test that variable for Null
if it is null i want to ignore the value else i have to print the value
can anyone help me on this
If ActiveCell.Offset(0, fixDateCol).Value = "ja" Then
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[" & repName & "],Fixed_Deliverdates_08!C[" & repName - 1 & "]:C[" & repName + monNum + 1 & "]," & monNum + 3 & ",0)"
End If
Cross Posted in http://www.mrexcel.com/forum/showthread.php?p=1672969#post1672969 also