Simple VBA IF THEN to fill a cell with a value

[NYEXCEL1]

I dont have much experience with VBA but know this would be the best way to populate a long document.

If I have a value in column B beginning with cell B2 put the value "2019" in cell J2

Thats it!!



Additionally, i currently use a formula to remove all the data in a cell after a particular character ("!"), using the FIND and LEFT functions, can you add the same formula to VBA and replace the cell with the updated value?

thanks all

 

[NYEXCEL1]

so per my first note, you can use formulas within VBA rather than .offset, etc?

 

[Fluff]

Yes you can using Evaluate, or you can just use VBA to insert the formula itself into the cells.