VBA, putting formula into empty cells.

[awsumchillicrab]

Hi, I'm really noob with VBA, and figure the best way to learn is with stuff that I really need in real life...

Because I can't seem to get good coherent VBA training tools online, and my library VBA books seem indefinitely booked.


I am looking for a way to scan through a column in my sheet, say Column B. If Column B meets some criteria (e.g. being empty), then I want a formula inputted into the cell. I would also want another formula inputted into the adjacent cells in Column C.

Any advice?

 

[VoG]

Maybe something like

Sub test()
On Error Resume Next
With Columns("B").SpecialCells(xlCellTypeBlanks)
    .Formula = "=A1"
    .Offset(, 1).Formula = "=B1"
End With
End Sub