I am using excel 2007 and using a vba which deletes rows

so i want a vba code so that after deleting rows from my vba i can put formula in the c of my excel sheet

i will give the formula in the vba code..plz mention space for that ,and after using my vba i will click your vba to put this formula