Insert Formulas

[Marlowwe]

Hello,

can you please help me with this macro ?

Need to paste formula with exactly the same formula. Copy cell C2 and paste to cells F2 and F3 as " My type of Formula" with same formula. If you copy and paste Ctr+C a Ctrl+V you will have formula=D2*E2.

	A	B	C	D	E	F	G
1	Unit price	Q-ty	Total
2	1	2	=A2*B2			=A2*B2
3						=A2*B2

<tbody>
</tbody>

Do you know what i mean ? Thank you

 

[njimack]

=$a2*$b2

 

[Marlowwe]

=$a2*$b2

I know that formula. But I have folmula with 20 cells input and do not want to put $ before cells location.

I copy a cell with formula, select final cell and run the macro.

What macro do:

Paste from copied cell the same Formula (does not matter if has imput from 20cells or only from 2 cells). You can do it maually: Go into cell, select all formula, copy, Go to new cell, paste and click enter

 

[JeanKim]

I know that formula. But I have folmula with 20 cells input and do not want to put $ before cells location.

Why do you not want to put $ sign before the cell reference?
you know you can use autofill to extend the formula?
example:

Set sourceRange = Worksheets("Sheet1").Range("A1:A2") 
Set fillRange = Worksheets("Sheet1").Range("A1:A20") 
sourceRange.AutoFill Destination:=fillRange

if you want same formula then use =$a$2*$b$2

although I have no idea why you would want that ....

 

[njimack]

The correct approach would have been to construct your file using absolute references but if you're looking for a VBA method to copy/paste formulae, tweak the below code to reference the correct ranges

Range("B1").Formula = Range("A1").Formula

 

[Marlowwe]

The correct approach would have been to construct your file using absolute references but if you're looking for a VBA method to copy/paste formulae, tweak the below code to reference the correct ranges

Range("B1").Formula = Range("A1").Formula

I need thic macro :

https://www.extendoffice.com/product/kutools-for-excel/excel-exact-formula-copy.html