vba to inset a formula into a cell

[hitch_hiker]

I have an invoice system , once the data is entered , at the press of a button the worksheet is copied and renamed, as well as printed as a "picking ticket", the input sheet is then cleared of all data and left with the vlookups and formulae, all this works perfect. Sometimes some data is written into cells which replaces the vlookup, as part of my resetting vba, can I get it to replace the cells with the vlookup. E.g. cell a4 has the following vlookup =VLOOKUP(A3,'Customer List'!B:L,2,FALSE), a5 is the same except B:L,3, a6 ~ B:L,4 etc

I'm thinking
activecell = a4
activecell = "=VLOOKUP(A3,'Customer List'!B:L,2,FALSE)"

or could I just go

a4 = "=VLOOKUP(A3,'Customer List'!B:L,2,FALSE)"

not really sure on syntax nor correct commands etc

 

[VoG]

Like this?

Range("A4").Formula = "=VLOOKUP(A3,'Customer List'!B:L,2,FALSE)"

 

[hitch_hiker]

thanks heaps VoG,
I usually know what I want to do , but I struggle on the actual code. but this was just a random tidy up to finish the project off. all works and works well , though I could probably streamline the code but, I don't have to