Script for putting a formula in a cell (VBA)

[D_Licious]

hi everyone,

so this code, which I've used successfully in the past, is failing me today:

[LEFT][COLOR=#222222][FONT=arial]Range("L2").Select[/FONT][/COLOR][COLOR=#222222][FONT=arial]        
ActiveCell.FormulaR1C1 = _[/FONT][/COLOR][COLOR=#222222][FONT=arial]        "=VLOOKUP(RC[-9],'[PAID INVOICE Q4-jj.xlsx]Sheet2'!C1:C5,4,<wbr style="display: inline-block;">FALSE)"[/FONT][/COLOR][COLOR=#222222][FONT=arial]    
Range("L2").Select[/FONT][/COLOR][COLOR=#222222][FONT=arial]    
Selection.Copy[/FONT][/COLOR][COLOR=#222222][FONT=arial]    
Range("L3").Select[/FONT][/COLOR][COLOR=#222222][FONT=arial]   Range(Selection, Selection.End(xlDown)).Select[/FONT][/COLOR][COLOR=#222222][FONT=arial]    
Range("L3:L1499").Select[/FONT][/COLOR][COLOR=#222222][FONT=arial]    
ActiveSheet.Paste[/FONT][/COLOR][COLOR=#222222][FONT=arial]    
Application.CutCopyMode = False[/FONT][/COLOR]
[/LEFT]

I simply want to put that formula into L2, but I'm getting an error. If you could respond quickly, it would be very appreciated, as this is for some commission calculations that are due very soon :/

thank you,

 

[mole999]

is it going to the page you expect ?

The L3 code, use one or other

consider

Range("L2").Select
ActiveCell.FormulaR1C1 = _

to

Range("L2").FormulaR1C1 = _