How to use Excel "Function Argument" Dialog in C#.net.

hi,

you can go to the following article:

http://support.microsoft.com/kb/302084

i hope it'll help you a lot. so don't forget to mark it

hi friend,

Following code will help you in calling formula to the relative cells in excel using function. see following code:

//Fill C2:C6 with a relative formula (=A2 & " " & B2).
         oRng = oSheet.get_Range("C2", "C6");
        oRng.Formula = "=A2 & \" \" & B2";

        //Fill D2:D6 with a formula(=RAND()*100000) and apply format.
          oRng = oSheet.get_Range("D2", "D6");
          oRng.Formula = "=RAND()*100000";
          oRng.NumberFormat = "$0.00";

Mark the answer if it helps.