Add formula to cell ignore cells that already has a formula

[Petter120]

Hi!

1. I add, edit and delete the values in column A and B trough a userform.
2. When a new row is added in column A and B i run a macro that adds formulas pretty much column C to Y.
3. The problem i have is that if a cell already contains a formula it adds it again and this slows the workbook down verry much (Everytime the macro runs it add 486 formulas)
4. How do i make this more effective, lets say it skips cells that already have a formula.

For more detail instruktion see my workbook: Add_formula_to_cell.xlsm

This is the code i use right now:

Please Login or Register  to view this content.

I use Swedish version of excel: (For the attached workbook)
SUMMA.OMF = SUMIFS
ANTAL.OMF = COUNTIFS
OM = IF

Petter

[Pauleyb]

1) Have you thought of using a table? It will add formulas to new rows automatically.
2) For your workbook, it looks like you can use column C (or D or E) to determine the 'empty' rows. So, something like this:

Please Login or Register  to view this content.

[Petter120]

I went with this solution, ok i much but it do what i want it to do.

Please Login or Register  to view this content.