Put Formula in newly inserted cells

Seems to work OK for me.

Upload the workbook and describe EXACTLY which cells you are selecting, what you expect to be the result and what result you ACTUALLY get.

Sorry for the confusion.

It will copy the above formula,

But the problem is, it will also copy the values.

I need to insert cell with same formula but has no values on it.

There are no specific cell range because it could be inserted anywhere within column A to Column G only.

Is it possible if I can insert this cells with below formula?

the scenario is like this,

Example:
I'm going to insert new cells between row 11 and row 12.
going to select A12:G12
then Insert new cells with below formula.

Range("A12").Formula = ""
Range("B12").Formula = ""
Range("C12").Formula = ""
Range("D12").Formula = "=C12"
Range("E12").Formula = "=F12-C12"
Range("F12").Formula = "=C12"
Range("G12").Formula = "=F12/$J$2*$K$2"

The sheet is protected.
and using macro, just highlight the cells and click "new lineitem" macro button(Column A-G)

My problem is, there are no specific range. Depends on where it needs to be inserted.
Its just cells from Column A to Column G only.

Thank you for your help. Hope I stated it clearly.

God Bless.

Hi,

My general approach for all stuff like this where you want to add a new row with formulae is to keep a master copy of the row with the formulae in place (I generally name this range "NewRecord" and keep it in hidden row 1.

Then all you need do when adding new cells with the cursor on the row to be inserted

Please Login or Register  to view this content.