Copy formula with vba

[wikus]

I would appreciate some help.
I have to copy a formula with vba to a certain amount of rows. The problem is the formula has cell references which must increase as the formula is copied down.

 

[VBACO]

I would have to see your code, but I think PasteSpecial is what you are looking for.

 

[mawdo]

You probalby want something like:

Range("A1:A200").FormulaR1C1 = "=SUM(RC[1]:RC[5])"

It would help to know:
1. Formula you need to insert
2. Range you want it to go in
3. More details about

The problem is the formula has cell references which must increase as the formula is copied down.

Hope that helps

 

[wikus]

The formula I am copying:
=HsSetValue($E11,$B$9,"Account#"&$D11,"Entity#"&$B$6,"Scenario#"&$B$2,"Period#"&$B$4,"Year#"&$B$3,"Value#"&$B$8,"ICP#[ICP None]","Custom1#[None]","Custom2#[None]","Custom3#[None]","Custom4#[None]","View#YTD")
When the formula is copied the reference to E11 and D11 for instance should increase to 12, 13, 14 etc when the formula is copied

 

[VBACO]

This works for me.

ActiveCell.PasteSpecial xlPasteFormulas

 

[wikus]

Thanks, I think this will work.