Macro will not paste data in range

[REHANSRSPL]

Please help me !


I have one problem in excel sheet.EXCELFORM.xlsm
Which i attach with this post.


My range of souce data change every time
that is my problem to run macro in this.

[HaHoBe]

Hi, REHANSRSPL,

Sub Macro1()
'
' Macro1 Macro
'

'
    Range("E4").FormulaR1C1 = "SS"
    Range("E5").FormulaR1C1 = "=+RC[-2]-RC[-1]"
    Range("E5").AutoFill Destination:=Range("E5:E" & Cells(Rows.Count, "D").End(xlUp).Row)
End Sub

Ciao,
Holger

[REHANSRSPL]

Thanks a lot !

[REHANSRSPL]

One more thing dear if i want to use +concatenate(c1+d1) or other formula

then what i do this please expl
i am new in vb editing

[HaHoBe]

Hi, REHANSRSPL,

concatenate won´t work with a + in between as it expects the ranges which should be pout together in a cell like (in R1C1)

=CONCATENATE(RC[-2],RC[-1])

R1C1 depends an the active cell row and column , here it shows that the R is the same as the cell the formula is put in while C indicates 2 columns to left resp. 1 to the left of the original cell. Writing it in A1-Notification the formula should look like

=CONCATENATE(C6841,D6841)

The first formula could be placed into the code without problem as VBA expects the formula to be i R1C1-Notifcation:

Range("E5").FormulaR1C1 = "=CONCATENATE(RC[-2],RC[-1])"

Best way maybe to find out about a formula to use in VBA is to type it into the cell, let that cell be the active one, change into the VBE and type into the Immediate Window(CTRL+G):

?ActiveCell.FormulaR1C1

and hit Enter.

Please note that Excel doesn´t need an + or - to start a function which you can start either using the Function Wizard or by typing = into the cell directly.

HTH,
Holger

[REHANSRSPL]

Thanks
for your help!