Vba to put a excel formula in a column

[ROHAN999]

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

[mahaveersomani]

give me a sample file with your vba code and give me the formula i will make it for you.

then it will run with a single click only. no need to click twice....

REgards
CA Mahaveer Somani

[ROHAN999]

Oh great..i am giving you in a few moments...

[ROHAN999]

But my formula is not yet prepared fully.....put any dummy formula and tell me..afterward i will replace that in the code

[mahaveersomani]

ok give me the code and any dummy formula and give me the cell adress where you want to put the formula.

[HaHoBe]

Hi, ROHAN999,

you should at least indicate if you want to apply Formula, FormulaR1C1 or FormulaArray.

Please Login or Register  to view this content.

Ciao,
Holger